What Data format is needed to get correct percent values 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

[Anonymous]

pls check attached file

[Anonymous]

sum(margin)/ sum(freight) worked in chart expression but not in script, why so?

Anyway, thanks as this worked for the current need.