ignore selection with set expressions

[#1]

Hi all,

I'm trying to ignore selections in the field [Booking Month] and at the same time forcing to get the higher value for the field [Booking Week] with this formula and it's not working:

sum({<[Booking Month],[Booking Week]={"$(=date(max([Booking Week])))"} >}Pax)

If I use the next formula I ignore the selection made in [Booking Month] field:

sum({<[Booking Month]} >}Pax)

and if I use the next formula I will get the result for the higher value for [Booking Week] field:

sum({<[Booking Week]={"$(=date(max([Booking Week])))"} >}Pax)

Do you know how can I combine both? maybe is because both dimensions are related?

thanks,

David

[trdandamudi]

May be as below:

sum({<[Booking Month]=,[Booking Week]={"$(=date(max([Booking Week])))"} >}Pax)

[#3]

Thanks but it doesn't work eihter

[swuehl · Accepted solution]

Are you looking for clearing user selections also in the max() aggregation?

sum({<[Booking Month],[Booking Week]={"$(=date(max({<[Booking Month]>} [Booking Week])))"} >}Pax)

[#5]

That's the solution,

Thanks a lot Swuehl!!