Expression to check value from same dimension

[qv_bazz_10]

Hi guys,

I have a report with monthly data and I'm trying to check if a value for the same dimension has changed from the previous month.

For example, for the following "P", I have a chart with "YearMonth" in column ("202007" = Jul 2020, "202008" = Aug 2020) and in expression I've put another dimension ("TM") to have the value of "TM" for each YearMonth:

As you can see, for the first "P" the value does not change from Jul 2020 to Aug 2020 (was and remains E) but for the second there's a variation from E to G.

Is there a way to check if there is a variation like the one you can see in the second record? Something basic like "Yes" or "NO" would be perfect.

Thanks in advance,

Andrea

[dplr-rn]

yes its posssible with set analysis or if statments.

please elaborate how you want to display it

[qv_bazz_10]

Hi Dilipranjith,

first of all, thanks for your reply.

It's the same, maybe would be easier with an if statement but, if possible, could you please show me both ways?

Thanks again,

Andrea

[qv_bazz_10]

Any help?

Thanks in advance,

Andrea

[Brett_Bleess]

@dplr-rn Sorry about the notifications not working well at the moment, just wanted to let you know the poster did respond back to you, not sure the info provided is enough, but I will let you respond back on that.

Regards,
Brett

[Kushal_Chawda]

@qv_bazz_10  You will have many months so how you are going check this condition?

[qv_bazz_10]

Hello @Kushal_Chawda ,

first of all I should check the YM (yearmonth, text field) to find any previous one, then I'd have to check the values to find out if there's a change, is there a way to do both tasks?

Thanks in advance,

Andrea