Question about an avg in pivottable

[francisvandergr]

I have a pivottable with the dimensions year and period. At the end i want an total (avg of 3 years).

Because i want one column i have used an dimension. Otherwise i get for every year an avg,

My formula for the dimension is :  =aggr(avg(Turnover),Period)

I want tghis formula with set analyses. I wanna have only Account 10 in m y calculation is this possible. I have included an example.

[giakoum]

aggr(avg({<aCCOUNT={"10"}>} Turnover),Period)

[swuehl]

Maybe like attached?

[francisvandergr]

Sorry Swuehl. I wanna have both. So i wanna have a subtotal and i wanna have an Average. Can i do something with an dimension ?

[swuehl · Accepted solution]

You want it more like this?

[francisvandergr]

Top!