Handling percentage when drilling down

[#1]

Hello,

Plz find attached I have an issue with calculating percentage while drilling down and drilling up.

[MarcoWedel]

as sum(Actual)/12  actually calculates the monthly average for the year dimension, you might as well change your expression to simply

Avg(Actual)

regardless of the selected drill down dimension.

see also:

Handling %

hope this helps

regards

Marco