Finding Max Week value on Selection of Month and Year for Specific Dimension value

[KishorePandurangan]

Hi All,

I have requirement where i should be able to pick only the maximum weeks values on selection of a month/Year and only on one dimension field value in the chart.

I have explained it below,

Please help me in achieving it through the script or in front end. I mostly prefer it in the backend.

I have also attached the sample file with data.

Thanks.

[sunny_talwar]

For Current Month (Feb), how are you getting Butter and Cookie = 120, but Milk = 40? Milk is related to Week 3 value, but Butter and Cookies are sum of Week 1, 2, and 3?

[KishorePandurangan]

Yes, Milk should take only the Max week value of selected month(i.e week3 and value is 40), whereas butter and cookie should give sum of all three weeks that is 120

[qliksus]

Maybe something like the below 

sum({<product=-{"Milk"}>+<product={"Milk"},Yearmonth={$(=max(Yearmonth))},Weekno={$(=max(Weekno))}>}amount) 

[Brett_Bleess]

Kishore, did Qliksus' latest response get you what you needed?  If so, please be sure to return to the thread to close things out properly by using the Accept as Solution button on Qliksus' post, that will give them credit for the assistance and let other Members know it worked.  

Regards,
Brett