Selection of Minimum Dates in Bar Chart

[sspawar88]

Hi Community,

I have one Bar Chart in which Dimension is MonthYear ( i.e Dec2016, Jan2017, Feb2017) and Expression is Sum(Sales)

So here requirement is :

When i select Jan2017 in list Box the bar chart has to show bar & values for only Jan2017 and Dec2016 and When i select Feb2017 in list Box the bar chart has to show bar & values for only Feb2017, Jan2017 and Dec2016

Thanks In Advance

[varshavig12]

Hi Satish,

I would request you to mark the above comment as the correct answer.

The formula provided by Manish.

This will be helpful for others in future.

Regards,

Varsha.

[sspawar88]

Sure Varsha