Show Average instead of Total in pivot table

[#1]

Hi,

How to show Average instead of Total in pivot table?

Thanks,

[MK_QSL]

Share your sample data.... you can use Aggr and Avg function to achieve the desired result.

[arjunkrishnan]

Simply Use Avg Function In Expression...In Presentation tab Show U Partial Total In Ur Dimension Wise....