Set analysis - Orders of sets

[#1]

Hi all,

when we do selections in the listboxes, due to the way you design the data layer, other fields can result in having some values grayed-out so the user usually selects only the available ones.

I need to apply this idea to two sets of a set analysis expression. Let's say I have the below table:

Year	Semester	Units
2012	1	30
2012	2	10
2013	1	20

if I do the following set analysis

sum({$<Year = {"$(=max(Year))"}, Semester = {"$(=max(Semester))"}>}Units)

I get 0 because it is trying to do Year = 2013, Semester = 2. Obviously I would like to get 20 (Year = 2013, Semester = 1).

Is this possible? If yes, how?

Thank you so much.

[Gysbert_Wassenaar · Accepted solution]

Try:

sum({$<Year = {"$(=max(Year))"}, Semester = {"$(=max({$<Year = {"$(=max(Year))"}>} Semester))"}>}Units)

[#3]

It seems working! Thank you!