Pivot Problem: Calc percentages on upper dimension totals

[hugmarcel]

Hi

see test.qvw example attached, I do not manage to calculate percentages correctly, where the percentages depend on upper dimension totals.

Thx a lot for any suggestion.

Note that the underlying data model must not be changed!

Marcel

[hugmarcel]

your formula is not correct, see file from Varsha Shashidhar 29.01.2014 08:09, very helpful and almost correct!

Marcel

[#3]

try to suppress null values in dimensions tab

[hugmarcel]

Hi,

this will not work, as suppressing the NULL Products will suppress all call numbers.

However, I found a solution, based on usage of "dimensionality()" to use the correct formula depending on dimension level.

Thx a lot again for your help, and some greetings from Switzerland to a pretty supporter!

Marcel