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

[#2]

Hi Satish

What will happen when you select May 2017?

Just want to understand your full requirement.

Regards

[sspawar88]

Hi,

It should select May2017, April2017, Mar2017, Feb2017, Jan2017, Dec2016.

Here Concern is only to select Minimum & equal dates value

[varshavig12]

Try this:

=sum({<MonthYear={"<=$(=Max(MonthYear))"}>}sales)

[MK_QSL]

Try this as bar chart expression

SUM({<MonthYear = {"<=$(=Date(Max(MonthYear),'MMMYYYY'))"}>}Sales)

[sspawar88]

Hi Varsha,

Actaully i'm using two Expression one is Sum(Sales) & Second is Sum(Bonus)

I was just want to know the possible ways of doing this.

When i'm using

=sum({<MonthYear={"<=$(=Max(MonthYear))"}>}sales)

it shows error in calculated dimension.

[sspawar88]

Hi Manish,

It shows no data to display.

[Anonymous]

Hi,

    As your requirement shows YTD I have developed sample YTD and Rolling 12 Months KPIs...

-Jai

[varshavig12]

Your dimension should be MonthYear

and Expression: =sum({<MonthYear={"<=$(=Max(MonthYear))"}>}sales)

[MK_QSL · Accepted solution]

Provide sample data or sample application.

My expression working in my application.