Set Anlysis

[#1]

I want to show the sale on the max year

So what will be the set analysis expression??

[#2]

Hi Amit,

something along the line of

Sum({<[YearField]={$(=Max([YearField]))}>} Sales)

should work

hope that helps

Joe

[jyothish8807]

Hi Amit,

try this:

Year should be your field according to your app?

sum({<Year={'$(=Max(Year)'}>}Sales)

Regards

KC

[PrashantSangle]

Hi,

Try like

Sum({<Year={"$(=max(Year))"}>}Sales)

Regards

[#5]

its not working gyes

[#6]

It works for me, see attached (make sure your spelling is exact with the field names, sometimes I type it without a capital letter to start and it loks correct but it errors as it doesn't recognise the field).

Good Luck

[PradeepReddy]

Try like this..

sum({<Year_Filed={'$(=Max(Year_Field)'}>}Sales)

[jyothish8807]

Please share your app, it may be because of different field name or any other mismatches.

Regards

KC

[#9]

Company_Sale:
LOAD Name,
     Year,
     Sales as [Sale Unit]
FROM
$(vPath)Assignment\19-11 assgn\Data.xlsx
(ooxml, embedded labels, table is Sheet3);

[#10]

sum({<Year={'$(=Max(Year))'}>}[Sale Unit])