Skip to Content
0
Jul 26, 2016 at 09:46 AM

Variables for 0calmotn

66 Views

Hi all,

I gave a query with variable (VAR1) based on 0calmotn.

I have created two restricted key figures (KeyN and key N-1).

KeyN based on VAR1 and Key N-1 based on VAR2.

VAR2 is a exit variable to get the period of the last year.

When i lauch my query for example with variable1 = 02.2016

I get this result :

02.2015 02.2016

KEY N KEY N-1 KEY N KEY N-1 258 789 233 2225 785 458

we need to not display the 0calmonth for 02.2015 to get this result :

02.2016

KEY N KEY N-1 789 258

2225

233 458 785

Can you help me please?

Thank you.