Pivot tables percentages

[Peo Sjoblom]

There is a field setting where you can set this as "show data as % of total"

 

[Kumar]

Pivot tables percentages how to avoid summing of % but get the real %

 

[Kumar]

Revenue 1000
G Margin 550
G. Margin% 55%
It is the 55% that is coming out as wrong being addition of individul units

 

[Kumar]

But that sets the whole colum to %, i need only that cell (row) to be %