create a average in pivot table

[kumarkp412]

Hi friends ,

Is it possible to create to averages in the pivot table?

In the pivot table properties , it is having total and partial sum of the dimension.i didn't fine any other option to get the average.

Is that we have to create a expression to get the average of the columns?

can any one give me one example ?

Thanks in advance

Kumar

[giakoum]

[kumarkp412]

Hi ioannis,

thanks for reply,

but in the pivot table this option is not available,

Thanks
Kumar

[giakoum]

try changing it to straight, enable the option and then back to pivot

[jonathandienst]

In a pivot table, you will need an Aggr expression of the form:

    =Avg(Aggr(<your current expression>, <your table dimensions>))

• Where <your current expression> is the expression that you want the average of.
• <your table dimensions>is a comma separated list of the fields in all the table dimensions

For example

     =Avg(Aggr(Sum(Expenses)/Sum(Sales), Year, Month, Day, Division))

HTH

Jonathan