Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to add a filter pane for the dimension [Category], while I already have another filter pane for the dimension [_MonthYear].
[_MonthYear] is a field of my Master Calendar and represents the last displayed month on my dashboard, which can cover a period of several months.
As there aren't all categories every month, some categories may be greyed out.
I've tried:
Aggr(Only({1} Category), Category)
as dimension of my filter pane, but they're still greyed.
I've also tried to include a set analysis like:
=Aggr({<$(vEmptyDate)>} Reporting,Reporting)
where the variable vEmptyDate is defined as:
%DateKey=, _Date=, _DayMonth=, _WeekDay=, _Week=, _WeekYear=, _Month=, _MonthYear=, ...
But it doesn't work neither.
What could be the solution?
Thank you in advance for your help.
Hello,
Have you found a way to keep all categories selectable with the selection of a specific month?
I have found a temporary solution, with the creation of a second master calendar, but I'm not sure it's the best solution