Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask ATLPROG Your Own Question

ATLPROG, Computer Software Engineer

Category: Programming

Satisfied Customers: 7677

Experience: MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

44910485

Type Your Programming Question Here...

ATLPROG is online now

I need excel calculated Formulas to capture my data, Excel

Customer Question

Hi, I need excel calculated Formulas to capture my data JA: What programs and versions are you using? Customer: Excel 2010 JA: What is your ideal outcome? How can we solve this for you? Customer: PIVOT table JA: Anything else you want the programmer to know before I connect you? Customer: Need an expert in EXCEL MS EXCEL

Please see my data in the excel tabel, I need two calculated tabular columns in excel for following formal..Max of order in a day(includes orders in every hour) /total orders in a day Max of order in an hour (includes orders in every min) /total orders in an hour

Thank You. I need two calculated fields in that pivot table..Max of order in a day(includes orders in every hour) /SUM orders in a day Max of order in an hour (includes orders in every min) /SUM orders in an hour

in my sheet there are orders in each min. right.I just need a formula in calulated filed for..=MAX(B3:Y3)/SUM(B3:Y3)

Customer:replied 6 months ago.

when I selected the date in slicer..it should shows the multiplier for specific date..which the formula is MAX(ORDERS in a day)/SUM(ORDERS in a day)

Customer:replied 6 months ago.

In the similar way..when I select hour in slicer..it should shows the multiplier for specific hour..which the formula is MAX(ORDERS in every min)/SUM(ORDERS in across the mins)

Customer:replied 6 months ago.

For exampleDate Multiplier 11/22/2015 11.54% 11/23/2015 10.05%

This is very simple but ..for me its not working out..and throwing error when tried to add calculated field. Just curious to know the logic behind that.

Thank You..I just need the following.. when I select the date in slicer..it should shows the multiplier for specific date..which the formula is MAX(ORDERS in a day)/SUM(ORDERS in a day) in the similar way..when I select an hour..it should describe percent for every hour across the days..MAX(ORDERS in an hour)/SUM(ORDERS in an hour)

Customer:replied 6 months ago.

Those should show up in PIVOT calculated fields, that's it.

I need below calculated files in the pivotDay Multiplier Hour Multiplier Minute multiplerDay Multiplier - Max(ORDER)/SUM of Orders in a day Hour Multiplier - Max(ORDER)/SUM of Orders in an hour Min Multiplier - Max(ORDER)/SUM of Orders in a min.

Customer:replied 6 months ago.

along with that in slicer if I select any date/hour/minute same formula should run based on the selection.Is this possible.

"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?

Sorry Steve. Yes.In pivot there is a option called calculated field right..so I wanted to have this formula via calculated field.Again sorry for the inconvenience caused..

I did like this..=MAX($B3:$B25)/SUM($B3:$B25) But the out put is not coming..and showing incorrect output

Customer:replied 6 months ago.

I have n number of orders in each hour and min across many dates..First I captured them in a pivot like as shown in the screen shot Please find the screen shot for more details.

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 27 and 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%

For example:See..today is 11/20 - assume over all order count in today is 30 I have orders like 0 hour - 1min - 4 2min - 5 3min -1 ... 59min - 32 hour 3 hour . , . 23 hour

Customer:replied 6 months ago.

I need to have the below dataDate wise Hour wise Min WiseSuppose if I select 20/11 ..then it shows..max order in an hour/sum of orders across the hours in a day (0, 1, ....23) Suppose if I select any hour ...lets say I selected 2'nd hour across dates - out come should be ..max order in 2'nd hour across dates/sum of orders across all dates listed in table. Suppose if I select any min ...lets say I selected 3'nd min across all dates - out come should be ..max order in 3'rd min across dates/sum of orders across all dates listed in table.

Customer:replied 6 months ago.

Hi Steve..you got my point. please go through the above comments, would be understand you better.Don't hesitate to ask me for any further questions. Thank you.

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.