8 Replies Latest reply on Sep 18, 2018 8:59 AM by Atishi Goyal

# Calculate percentage of difference from previous value to the base number

Hi All,

I am trying to do some analysis on cohort and stuck with one of the views I am trying to create.

View 1: The number of customers in each counter of every month.

View 2: Number of customers churned out so basically the January number in counter 2 is (534-458)

The calculation that I want is % of the numbers of view 2 with respect to the total along that row i.e     all numbers of view 2 in a row/(the base number 534)

• ###### 1. Re: Calculate percentage of difference from previous value to the base number

Hi Atishi,

You can use a Quick Table Calculation to get the percent difference:

Compute using Table Across:

and relative to previous:

I hope this helps.

Emmanuel.

• ###### 2. Re: Calculate percentage of difference from previous value to the base number

Hi EMMANUEL

The output in view 2 is itself a quick calculation, I am unable to add another quick table calculation

PFA attached

With such calculation how is it possible?

• ###### 3. Re: Calculate percentage of difference from previous value to the base number

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

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

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

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

Use these calculations to solve it:

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

Thanks Emmanuel!