Product level wise max month sales

[swatitomar]

Hi, friends! )

I need your consultation for the following problem. Show Month max sales on the basis of Product ID,Level,Category,Year,Month wise 

Note: Product is always by default selected in App.

Product ID	DumpMonth - Jan	DumpMonth - Feb	DumpMonth - Mar
123	23	24	456
234	23	23
345	45		67

If Product ID is a part of every month. I have to show max value only. Example

Tried aggr() with Max month but its not working in case Max month has no value. Showing 0 for 234 as it has no value for Mar month

Product	Sub category	Product ID	Level	Expected Value	Coming as
A	Source	123	1	456	456
A	Medium	345	2	67	67
A	Source	234	1	23	NOt coming

[Vegar]

Assuming you have some kind of year_month field (or are able to create one)

Try this:  Sum({<year_month={'$(=max(year_month))'} Sales)

Or this: Sum({<year_month={'$(=maxstring(year_month))'} Sales)

[swatitomar]

Hi, It is not giving value for the product where Max month is not Mar i.e. 234 Product ID