Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi,
Sample Data:
Result :
Set for Dim in Row:
Set Column:
set measure:
Try this, you will have result
K. Srinivasan
Try Using the AGGR Function