Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Are you looking for clearing user selections also in the max() aggregation?
sum({<[Booking Month],[Booking Week]={"$(=date(max({<[Booking Month]>} [Booking Week])))"} >}Pax)
May be as below:
sum({<[Booking Month]=,[Booking Week]={"$(=date(max([Booking Week])))"} >}Pax)
Thanks but it doesn't work eihter
Are you looking for clearing user selections also in the max() aggregation?
sum({<[Booking Month],[Booking Week]={"$(=date(max({<[Booking Month]>} [Booking Week])))"} >}Pax)
That's the solution,
Thanks a lot Swuehl!!