What format should be used to get percent in Pivot Table Chart

[Anonymous]

Hi,

I have used this below given formula to calculate the percent and added the field as expression in pivot table.

margin/Freight *100 as GM%

So, the calculation is correct for some values only.

The format used is integer and expression is sum(GM%).

PFA screenshot of my pivot where I've marked the wrong values in red and right ones in green.

Thanks

[Anil_Babu_Samineni]

May be missed the attachment

[Anonymous]

Sorry

Please check now .

[Anil_Babu_Samineni]

I already replied here What Data format is needed to get correct percent values in Pivot table chart.