Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have an issue in sorting using match function.
I used below code.
=match ( REGION, 'Australia', 'New Zealand', 'Asia', 'Pacific', 'Europe', 'Americas')
It works fine, but my pivot has a MTD Value using set analysis,
my MTD set is:
=Sum({<Day=, Month=, Date={'>=$(=Date(MonthStart(Min(Date))))<=$(=Max(Date))'}>} [Day Actuals])
Problem is, there wont be data available for all countries on few days in a month,
If data available for all countries on a day, the sort works fine,
when not available it does not work, but my pivot gives MTD data but it reflects all the countries in pivot.
Is there any way i nullify Day in sort? or use this expression in sort and has any work around ?
Appreciate your thoughts.
Regards
Ren
Perhaps this:
=match (only({<Day=>} REGION), 'Australia', 'New Zealand', 'Asia', 'Pacific', 'Europe', 'Americas')
Perhaps this:
=match (only({<Day=>} REGION), 'Australia', 'New Zealand', 'Asia', 'Pacific', 'Europe', 'Americas')
Works like charm ... Thanks much!!