How's it going.Let me read of your question. Give me a minute.
You'd like to create a pivot table. Is this correct?
Ok can you explain your requirements and send me the file for a look.
Hello,I am the person that will be helping you today.
It appears that the last expert has opted out. May I ask for you to describe what type of pivot table you are wanting from this document?
I will be standing by, looking forward to your response.
I am looking into it. Please, give me a few examples of what the end result values should be.
What value are you referring to when you say, "MAX(Orders in a Day)"?
What value are you referring to when you say, "MAX(Orders in a Min"?
Where did you get those values you just sent in? I will look at the sheet and make sense of it.
I wish to help you understand this, but before I can do so, I need to fully understand what you are searching for.
You gave the following information:Date Multiplier11/22/2015 11.54%11/23/2015 10.05%
"How" did you come up with those values?
Okay. Good day. Please, answer my questions so another will help.
Hi there, my name is***** declined to answer this question. Do you still need help with it?
You can click here to do a secure upload of the spreadsheet to my dropbox. I'm the only one who will see it and I'll delete it when we're done. That will be the fastest way for me to help you if I can look at it.
Or is the spreadsheet posted above the one you're currently working with?
So you want the number in the pivot table to be max(orders)/sum(orders)?
"I need below calculated files in the pivot"? I'm not sure what that means. What files? I'm sorry, but maybe English isn't your first language and I'm having trouble understanding what you want.
Right now, the values in the pivot table are sum(orders) for a particular time period, depending on what you selected. My understanding is that you want those instead to be max(orders)/sum(orders) for the same time period. Is that correct?
It's no problem, I just want to make sure I understand what you want. Hold on and let me do something and you can see if it's what you're after.
ok, i am looking at it now.
In your screen print example,
For 11/26/2014, the max orders per hour for hour 1 is 27, and the total orders per hour for hour 1 are 74. You want to multiply all values in the pivot table for 11/26/2014 and Hour 1 by 27/74 = .36
For 11/26/2014, the max orders per day are 27and the total orders per day are 97.You want to multiply all values in the pivot table for 11/26/2014, entire day by, 27/97 = 28%
Is that right?
hour peak order / orders in an hour ?
do you mean min(orders)/sum(orders) ?
I don't know what "hour peak order / orders in an hour" is
Yes. For all three. but then you said min peak order / orders in an hour. Is that something additional (the "min")?
What version of Excel are you using? Do you have PowerPivot? (a free add-on from Microsoft for Excel pivot tables.)
I'm glad you put that explanation because you never said it was to be across all dates. That's something different, but might be something easier to do. Hold on.
I'm really sorry but I'm not sure about the best way to do this, and I've spent quite a bit of time on it already. If I were you, I would probably just calculate the max per day, max per hour and max per minute in a macro, add those to your table and do it that way. Sorry about that.
For such ornate semantics, we use SQL, not Excel.