How to correct percentage in calculated item in pivot Table.

[Narayan Rath]

Dear Members,

How to change the % in calculated items in Pivot table. Please find attached file.
Why Grand Total gross Margin shows -13% instead of 10%.

Regards
narayan

 

[Nebu]

Here is the answer for your question