Hi all
I have a powerpivot table with 3 columns..
Column A has data labels
Column B has data expressed as a % of total column
Column C has data expressed as a % of total column (different data to Column B)
I'm trying to Index Column B % to Column C %
For instance the first entry in Column B is 75% and first entry in Column C is 70% - I'm trying to create a Measure that divides 75% by 70% giving the result 1.07 (positive index).
However the measure calculation appears to be performing the calculation on the data in its raw form rather than it expressed as a '% of total'
I hope this makes sense, if there a way round this?
Regards
I have a powerpivot table with 3 columns..
Column A has data labels
Column B has data expressed as a % of total column
Column C has data expressed as a % of total column (different data to Column B)
I'm trying to Index Column B % to Column C %
For instance the first entry in Column B is 75% and first entry in Column C is 70% - I'm trying to create a Measure that divides 75% by 70% giving the result 1.07 (positive index).
However the measure calculation appears to be performing the calculation on the data in its raw form rather than it expressed as a '% of total'
I hope this makes sense, if there a way round this?
Regards