How to show Average of Rows in Pivot Table

[SatyaPaleti]

Hi Friends,

Could some one guide me. How can we show a Average of Rows in Pivot Table.

I am having a data on Daily, Weekly & Monthly and Qty as a Metrics.  I am showing data like in below format.

Currently it is showng Sum of rows but I want to show Average of Rows. Average of both Jan & Feb Qty.   

Note: In Month level I want to show Sum but in Total I want to show Average.

Same process for Weekly & Daily also. Could some one please help me on this. Please find attached documents for Sample qvw & Sample Data.

Thanks and Regards,

Satya

[jaibau1993]

Hi Satya!

You can solve this issue using dimensionality and secondarydimensionality functions to write a diferent expression for "normal" cells and "total" cells. Please, see the attached file where I modified your expression!

Bests,

Jaime.

[SatyaPaleti]

Hi Jamie,

Thank you so much for your response. Could you please suggest how can we show the exact average for Total?. Total average is  Missing

Thanks and Regards,

satya

[jaibau1993]

Hi Satya!

What do you mean by "Total average is  Missing"? In my qvw document there are no missing values!

Otherwise, I realiced that the grand total was not correct (it was not the average of months totals!). I attach the corrected file.

Regards,

Jaime,