5 Replies Latest reply on Aug 31, 2016 10:11 AM by Austen Robinson

# calculating differences between months in percent

In the attached workbook I would like to have a column next to each month that displays the percent change.  Like Feb to Mar, Mar to Apr etc.  Also what I have now, the percentages seem off if I use a hand calculation.

• ###### 1. Re: calculating differences between months in percent

Hi Austen, it looks weird because your months are actually out of order relative to the columns. For instance, if you put the Month in the Rows shelf, you get this:

• ###### 2. Re: calculating differences between months in percent

Sorry what I really want is the sum of the four categories and that total is what I want in the percent difference.

• ###### 3. Re: calculating differences between months in percent

Do you mean like this?

• ###### 4. Re: calculating differences between months in percent

Not quite.  I need it to be like the screen shot in the attachment.  Churn is the percent difference month to month.

• ###### 5. Re: calculating differences between months in percent

Ive got it down to this:  Need to place percent difference of the total between each month starting with Jan and Feb.  Tried several calculated fields but nothing got me what I wanted.  I think you have to divide sum([total]) / sum([total]) somehow like in excel but not sure of the correct syntax let on how to insert it between the months on the total row.