Skip to main content
cancel
Showing results for 
Search instead 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.

error loading image

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

Thanks

1 Solution

Accepted Solutions
vgutkovsky
Master II
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,

View solution in original post

2 Replies
vgutkovsky
Master II
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

Vlad, thanks a lot!

It works perfect!