I am building a query which uses formulea on calculated key figures. I have a problem in that I want to report the calculated key figures at detail and total levels. I therefore need the formulae (not summation) to take effect on the total lines. I am having trouble making this work. It works fine at the detail level but on total lines I get summation and not the formula result.
I must be missing something!!