Multiple Months MTD

[sanjujeeboy]

Hi team,

my requirement is

If we select multiple months eg: if i select Jan Feb Mar 2019 it should compare with Jan Feb Mar 2018 sales

How to achieve this  in front end?

[sunny_talwar]

Without knowing how your data looks, it would be difficult to give you an exact response, but may be look into set analysis to do this

[sanjujeeboy]

Hi Sunny,

So i have sales data  for 2017 2018 2019....so the requirement here is if the user selects any months  eg Apr may June for 2019, i should get data for Apr may june 2018 also(ie last year same months) . If he selects Jan Feb 2018, then the data to show will be Jan Feb 2017.

Can you help on this ? and also if set analysis is to be used how to do that ?

[sunny_talwar]

I sure can try to help.... please share a sample so that I can help you 🙂

[kushalthakral]

Hi

In set analysis you can mention Max(Year)-1 which will always show selected year - 1 for the selected months

like example below

Sum({<Year = {$(=Max(Year)-1)}>}Sales)

Thanks

Kushal