Need to get the dates based on the Selected Dates

[bharatkishore]

Hi All,

I am having a month Filter where the data is from Jan to May-2016.

Now if what ever selections i will do it should be from Jan to selected month.

For example: I have an expression called sum(leads).

Now i selected month filter for march month .. so the value should be sum(leads) from jan to march.

if i selected april again it should be jan to april sum(leads).

Kindly help.

thanks,

Bharat

[marcus_sommer]

You could try something like this:

sum({< MonthNum = {">=$(=max(MonthNum))"}> leads)

- Marcus

[arulsettu · Accepted solution]

try this

Sum({<Datefield={">=$(=YearStart(Max(Datefield)))<=$(=Max(Datefield))"}>} leads)

use your date field

[bharatkishore]

Thank u exactly what i needed