How to calculate % increasement - current month VS previous month

[#1]

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

[vgutkovsky · Accepted solution]

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,

[#3]

Vlad, thanks a lot!

It works perfect!