-
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.
-
-
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.
