Relative percentage in column of pivot table

[marcel_olmo]

Hi guys, I have a straight table that looks like this :

It's quite easy to do thanks to the "relative check" button :

I want to do the same thing in a Pivot Table, but the problem is that there's no such a "relative check" button.

I know that an answer would be :

column1 : sum(Sales)

column2 : sum(Sales) / sum(TOTAL Sales) --> As a relative check.

But I have more than 20 complex expressions and I'm trying to avoid to create another 20 expressions with the TOTAL prefix.

Is there any way to do it easier? Maybe with some total column stuff?

Regards, Marcel.

[Clever_Anjos]

No shorcut, Rega you should rewrite your expressions

[Anonymous]

No Shortcut, need to follow the process

[HirisH_V7]

Hi,

Check this,

In Pivot same expression like  yours,change in Number format.

No shortcut copy paste all the expressions and do your changes for relative.

PFA

Hope this helps,

Hirish

[#5]

What if i do not want it to be relative to all dimensions?

how do i change the formulae?

[HirisH_V7]

Hi,

• Just un-tick relative for all expressions

• Change your expressions like Sum(Sales) only

• Check the number format to be as per your requirement.

HTH,

Hirish

[Chanty4u]

unchk for all expression it may works