Averages in a Pivot Table

Question

Hi,&nbsp;I need to show the average sales per day and average sales per month but when I select "Summarize value by Average", it shows wrong number, any solution to this issue would be highly appreciable.&nbsp;See attachments..&nbsp;

sergeibaklan · Answer

Hi Humayoan,&nbsp;From your screenshot it's not clear are all your data within one calendar year or not. If yes, in general it shall show correct&nbsp;result. If not, in grouping you shall select bot month and year, otherwise it'll be average for selected month for all years in range.

humayoan mustaqeem · Answer

Hi Sergei,Thank you for response, yes, my data is all within one calendar year, but it doesn't show correct result of average.

sergeibaklan · Answer

Another reason could be if you have checked "Include filtered items in totals" (PowerPivot Options, Totals and Filters, Filters).

humayoan mustaqeem · Answer

Apologies as I was on Eid Holidays, The option is not checked and the problem still exists, I have attached the excel file, if you can have a look and suggest the sollution, I would be highly thankful to you.&nbsp;Regards

sergeibaklan · Answer

Hi Humayon,&nbsp;IMHO, averages are calculated correctly if the mean average for the period.&nbsp;It is SUB of SoldQty / Count of SoldQty.&nbsp;Do you mean it shall be average per day included days when nothing was sold?

Forum Discussion

Averages in a Pivot Table

5 Replies

Resources