Pivot Table and general Average

[tenmaster10]

Hi Experts

Someone can support me as I can solve the following question.

I have a pivot table with the transactions per day and even the average side, the drawback is that this average is giving me per day and what I need is that in each day I show the total average.

currently this is the formula.

[Ksrinivasan]

hi,

Sample Data:

Result :

Set for Dim in Row:

Set Column:

set measure:

Try this, you will have result

K. Srinivasan

[anushree1]

Try Using the AGGR Function