cancel
Showing results for
Did you mean:
Not applicable

## How to calculate % increasement - current month VS previous month

Hi all,

I would like to calculate the % increase between 2 months and unable to do so. Following is the pivot that I am using.

Anyone know how to insert a column at the back showing the % increase when comparing to the previous month?

Thanks

1 Solution

Accepted Solutions
Master II

Sure, this is quite simple with the above() function, and is also possible with set analysis. I'm assuming you want the increase in User Sign In Count. So you have 2 expressions, the first being your existing Count and the second being the first expression divided by something like the following (substitute the proper fields of course): above(count(Users))

If your sort order is not by month, then you will need to do it with set analysis.

Regards,

2 Replies
Master II

Sure, this is quite simple with the above() function, and is also possible with set analysis. I'm assuming you want the increase in User Sign In Count. So you have 2 expressions, the first being your existing Count and the second being the first expression divided by something like the following (substitute the proper fields of course): above(count(Users))

If your sort order is not by month, then you will need to do it with set analysis.

Regards,

Not applicable
Author