Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You want it more like this?
aggr(avg({<aCCOUNT={"10"}>} Turnover),Period)
Maybe like attached?
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 ?
You want it more like this?
Top!