Percentage calculation on dimension subtotal

[#1]

Hello experts,

I have this scenario:

In a pivot table with 2 dimensions ("line" and "sector") and the following definition as expression:

=Sum(ImportoOrdinatoRiga) / sum(total ImportoOrdinatoRiga)

the above expression give me the percentage on "line" dimension total (grand total), while I need the percentage on the "sector" dimension total.

How can i achieve it?

thanks in advance.

Best regards

Andrea

[#2]

Try:

=Sum(ImportoOrdinatoRiga) / sum(total <sector> ImportoOrdinatoRiga)

That should give you the percentage of the sector. The denominator will be the sector total.

[#3]

i tried it but the results is the same!

[#4]

The same? That seems odd. What order are your dimensions in?

I actually think you'll need to use:

=Sum(ImportoOrdinatoRiga) / sum(total <line,sector> ImportoOrdinatoRiga)

But the original expression shouldn't have given you the same value as your expression. Try it with just the total sum as an expression.

[#5]

Please use this

=Sum(ImportoOrdinatoRiga) / sum(total <line> ImportoOrdinatoRiga)

[Anonymous]

Can we use the same concept in a bar chart?