Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be missed the attachment
Sorry
Please check now .
I already replied here What Data format is needed to get correct percent values in Pivot table chart.