compare result to result in second month of year

[curiousfellow]

I want to compare the number of employees with the number of employees in month 2 , as a percentage where month 2 is 100%.

I have two dimensions year and month. and an expression:

count(distinct employeenum)/before(count(distinct employeenum, month-2)

In a pivot table it works fine using the before() function.

However I want to present the result in a line chart, but cannot get it done. The before function() does not work in a line chart right ? Is there an alternative way to do this ?

[zhadrakas]

before() and after() are pivot table exclusive functions.
check above() and below() for the use in line charts.

regards
tim

[curiousfellow · Accepted solution]

Thank you for your answer, but it did not help.

When I use above,  it compares to x years before.

I solved it with this expression :

count(distinct employeenum)/count({<month={2}>} Total <year> employeenum)

I used something like this before, but did forget it 😁