mrchonginhk
Well-known Member
- Joined
- Dec 3, 2004
- Messages
- 679
I have to report average DAILY sales of certain products in Pivot Table, and my boss has make a must requriement for me to put in the page field a button for him so that he can select the view as Jan, Feb, mar... and Dec and of course ALL for the year. He is always interest to see the DAILY average sales for a particular month or for whole year not the monthly total or annual total.
So the data I gathered are under this column:-
Product, date, sales value
My initial attempt was to create a calculated field to divide sales by 31 to give the daily average. This works ONLY when he select Jan or Feb or.. Dec in page view. If he selects ALL, it is annual total sales divided by 31 which is meaningless.
Also not all months are 31 days.
How to tackle this extremely tricky questions ? I have used Pviot Table for years and I still cannot figure this out.
Any expert here can help me from getting fired ? He keeps asking me why I cannot do this "Simple" thing .... help !!!!!!!!!!!!!
ray:
So the data I gathered are under this column:-
Product, date, sales value
My initial attempt was to create a calculated field to divide sales by 31 to give the daily average. This works ONLY when he select Jan or Feb or.. Dec in page view. If he selects ALL, it is annual total sales divided by 31 which is meaningless.
Also not all months are 31 days.
How to tackle this extremely tricky questions ? I have used Pviot Table for years and I still cannot figure this out.
Any expert here can help me from getting fired ? He keeps asking me why I cannot do this "Simple" thing .... help !!!!!!!!!!!!!
