I’m trying to find the right formula to put in the Pivot table in order to calculate the BPS (Basis Points) difference between 2015 and 2017 market share.
Orange Juice in the Beverages category
Beverages = 100%
OJ market share 2017 = 20%
OJ market share 2015 = 10%
BPS should be = 1000 (10 percentage points difference).
I only know how to calculate the % Chg for this (this would be +100% here). But I can’t find a way to make the calculated field consider the market share values instead of actual litres. If there a way to solve this? I only have actual litres for 2015 and 2017 and would like the Pivot to dynamically change the BPS as I expan/collapse fields.