Show text only if the last 2 yrs of sales is trending down

[regowins]

Hi,

How do I conditionally show text only if the last 2 years for 'store A' sales is trending down? I know how to conditinoally hide and show text, just not sure how to capture the trending down for the last two years of sales.  Thanks for the help!

[Gysbert_Wassenaar · Accepted solution]

Something like this maybe:

=if( sum({<Store={'store A'}, Year={'$(=max(Year)-2)'}>}Sales) <  sum({<Store={'store A'}, Year={'$(=max(Year)-1)'}>}Sales) and sum({<Store={'store A'}, Year={'$(=max(Year)-1)'}>}Sales) <  sum({<Store={'store A'}, Year={'$(=max(Year))'}>}Sales), 'Show this text' )

[regowins]

Just what I needed ....Thanks!