Need average in Pivot Total

[naveeddil]

Dear All,

I have a dataset and for ease there is a pivot as in picture.
Excel.png


The months will increase by time i.e. Jan, Feb, Mar, etc; all i want is a column after Grand Total Showing City average over the period using pivot table by using =GrandTotal/# of Months

The yellow highlighted is calculated through Formula for each district.

Any help is appreciated.

Thank You

[cbatrody]

Hi,

Can you post the sample file in excel format rather than image?

[naveeddil]

Dear,

Here it is

Pivot.xlsx

[cbatrody]

I could do this after adding a helper column in the source data (see Column U, "NEEDED FORMAT" tab)

File attached!

[naveeddil]

Thanks for the reply.

It have inserted average Column after each month which i dont want to be there as its making the table long

[naveeddil]

Any Reply so far ?

Thank You