Selections is not working in using Identifier 1 in set analysis

[SatyaPaleti]

Hi Experts,

Could some one please help me on this. It's highly required.  I have  Month &-& Year as a Dimensions and I am calculating Last 12 Months data.

 I am using Following Expression

sum({1<Date={'>=$(=MonthStart(Max(Date),-12))<=$(=MonthEnd(Max(Date)))'}>} Price)

Here it is rolling last 12 months but it is irrespective of selections.  For Example I am having a Product LDPE it's overall Price in Jan-2019 1140. When I am selecting Product LDPE and Jan-2019 it have to show  22404. It's not considering Selection of Product's which I made.

Could some one Please help me on this. It's Very urgent. Please find attached document for sample data. Can some one please create sample qvf on this

Thanks and Regards,

Satya

[sunny_talwar · Accepted solution]

Why do you need 1 then? Get rid of it?

Sum({<Date = {'>=$(=MonthStart(Max(Date),-12))<=$(=MonthEnd(Max(Date)))'}>} Price)

Or if you only need to allow selection in Product, try this

Sum({1<Date = {'>=$(=MonthStart(Max(Date),-12))<=$(=MonthEnd(Max(Date)))'}, Product = $::Product>} Price)

[SatyaPaleti]

Hi Sunny,

Thank you so much for your response on this