Need Help For Sum Function

[Anonymous]

Hi All,

When I make multiple selections on the data model, I want the biggest year's data to be processed. Code structure;

(((Sum({$<Year={"=$(=(Max(Year)))"}, Month={"<=$(=(Max(Month)))"}> } In_Qty)) -

(Sum({$<Year={"=$(=(Max(Year)))"}, Month={"<=$(=(Max(Month)))"}>} Out_Qty))))

When I choose all years sum data for all years but i want the only biggest year in my selection.

Please help me.

[shiveshsingh]

Try removing '=' sign before $ in Year set analysis.

{$<Year={"$(=(Max(Year)))"}