This content has been marked as final.
Show 2 replies

1. Re: Calculating Percent Difference of a Percent
Imran Siddiq Dec 30, 2016 5:45 AM (in response to Imran Siddiq)1 of 1 people found this helpfulAnswered with the following.
Created the Quick Calc again as a Created Calculation.
And the performed this onto it:
([Calculation1] LOOKUP([Calculation1],1))/LOOKUP([Calculation1],1)

2. Re: Calculating Percent Difference of a Percent
Brian Connelly Dec 30, 2016 11:41 AM (in response to Imran Siddiq)1 of 1 people found this helpfulBuilding onto what Imran has mentioned (which is correct), do the following for easier implementation and readability:
1) Take your original measure (the SUM(Value) calculation) and drag and drop it into your Measures.
2) This will create a Calculation which you can name, maybe something like "Percent of Total"
3) Then using Imran's suggestion, create a new calculation like: ([Percent of Total] LOOKUP([Percent of Total],1))/LOOKUP([Percent of Total],1)
4) Add this new Measure to your Worksheet.