Hi!
I am using the following (simplified) function:
SUM({<[USE_Reporting month] = {"$(=max([USE_Reporting month]))"}>*<[Data complete]={1}>},[USE.Quantity])
I have a filter dimension on 'country', and the condition 'Data complete = 1' is different per country (e.g. for some countries we have data complete up to august, for others only until june). I want this function to give me the latest (MAX) month where 'Cumulative to date = 1 applies to all selected countries. How do I do this?
Thanks a lot!