
2. Re: Calculate percentage of difference from previous value to the base number
Atishi Goyal Sep 18, 2018 3:29 AM (in response to Emmanuel Ikehi)Hi EMMANUEL
The output in view 2 is itself a quick calculation, I am unable to add another quick table calculation
With such calculation how is it possible?

3. Re: Calculate percentage of difference from previous value to the base number
Emmanuel Ikehi Sep 18, 2018 3:35 AM (in response to Atishi Goyal)Edit the current table calculation and change it to Percent Difference From.

4. Re: Calculate percentage of difference from previous value to the base number
Atishi Goyal Sep 18, 2018 3:50 AM (in response to Emmanuel Ikehi)Yeah, but then the percentage difference it gives is relative to the previous one , what I want is that the denominator must be a single number across the row i.e. the first one

5. Re: Calculate percentage of difference from previous value to the base number
Emmanuel Ikehi Sep 18, 2018 3:58 AM (in response to Atishi Goyal)Your explanation is not clear. Can you give a better description of what you want?

6. Re: Calculate percentage of difference from previous value to the base number
Atishi Goyal Sep 18, 2018 4:03 AM (in response to Emmanuel Ikehi)In your explanation the base is changing for every number, I want the base to be fixed, as in the images shared by me in the first message, in January 2018, for all order counters from 1 to 15 the denominator while calculating the % must be 534 across, which is also the sum of all the January 2018 numbers in view 2,
So basically what I want is first the difference between the previous and then the percentage of the difference relative to one single base number for all order counters

7. Re: Calculate percentage of difference from previous value to the base number
Emmanuel Ikehi Sep 18, 2018 5:09 AM (in response to Atishi Goyal)Use these calculations to solve it:
Difference = SUM([Your Measure])  LOOKUP(SUM([Your Measure]), 1)
computed along Order Counter
First Number = LOOKUP(SUM([Your Measure]), FIRST())
computed along Order Counter
Finally, calculate Difference/First Number
This should help. If it's what you need, please mark this as helpful or as 'correct answer' to close this case.
Emmanuel.

8. Re: Calculate percentage of difference from previous value to the base number
Atishi Goyal Sep 18, 2018 8:59 AM (in response to Emmanuel Ikehi)Thanks Emmanuel!