In month field, It will display the Jan to selected month.

[Ramu_i]

Hi All,

I have year and Month fields, KPI's are there, 

If select the year field in year , If I select the Month in Month fields , it will display the Jan to selected month data,

Means , If I select the Apr month--- It will display the Jan to Apr data, If I selected the Nov month --- It will display the Jan to Nov Data.

I have used Min >= and <=Max values , But here Min and Max taken selected value, 

Please find the solution.

Thanks Advance 

Ram

[anat]

=sum({<date={">=$(=addmonths(max(date),-6))<=$(=max(date))"}>}sal)

can u try like above,

[anat]

=sum({<date={">=$(=yearstart(date))<=$(=max(date))"}>}sal)

[Ramu_i]

Hi Anat,

It's not working.

Thank you

Ram