Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to show the sale on the max year
So what will be the set analysis expression??
Hi Amit,
something along the line of
Sum({<[YearField]={$(=Max([YearField]))}>} Sales)
should work
hope that helps
Joe
Hi Amit,
try this:
Year should be your field according to your app?
sum({<Year={'$(=Max(Year)'}>}Sales)
Regards
KC
Hi,
Try like
Sum({<Year={"$(=max(Year))"}>}Sales)
Regards
its not working gyes
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
Try like this..
sum({<Year_Filed={'$(=Max(Year_Field)'}>}Sales)
Please share your app, it may be because of different field name or any other mismatches.
Regards
KC
Company_Sale:
LOAD Name,
Year,
Sales as [Sale Unit]
FROM
$(vPath)Assignment\19-11 assgn\Data.xlsx
(ooxml, embedded labels, table is Sheet3);
sum({<Year={'$(=Max(Year))'}>}[Sale Unit])