Line Chart- How to see historical data if we select any month from filter pane?

[#1]

Hi,

I have line chart which has "Month" in X-Axis and measure in Y-Axis. If I select any month from filter pane I should see historical data till that selected month. For example if I select "DEC-16" I should see data which is available before Dec-16 including December data in the line chart.

[aarkay29]

May be this

Give the expression as Sum({<Month={'<=$(=Max(Month))'}>}Field)

[ahaahaaha]

Hi Pradeep,

It can be so

Sum({<Month={"<=$(=Month(GetFieldSelections(Date)))"}>}Field)

I do not know how the date fields are organized.

Regards,

Andrey