Hi there
I'm new at the forum and an advanced user in excel but i'm having a problem on my pivot tables.
I introduced a percentage calculated item on my pivot table but on the far right where is the column that sums, it's "summing" all the percentages.
Is there any way to fix this?
What i want is, in the image below, replace the yellow cells with a percentage (Margin / Sales)
test.jpg
thanks
Bookmarks