Pivot table: Sumifs with calculated fields

[Tarek78]

Hi Everyone,

I have been asking myself this questions for a few years without any answer.

I have a simple pivot table as per attached. I have for each year the revenue and margin value per account. I want to calculate a margin percentage using the calculatated fields functions.

Is that feasible?

Thanks

 

[Tarek78]

Any one who could help me on this one? I am stuck

 

[RoryA]

Can you not just add a calculated field that divides one by the other?

 

[Tarek78]

Hi Everyone, I found my answer! I had to use a calculated item and not calculated field!