I have a module with 2 lists (currency and tasks) as dimensions and a boolean line item.
Im trying to apply filter on the boolean line item, if TRUE then only the respective currencies satisfying the boolean condition from currency list should be displayed.
Im trying to apply filter but its not working as Task and currencies are in rows/columns.
I tried changing the pivot, made them on pages applied filter and again repivoted back to rows/cols, but it doesnt work.
Please can anyone help on this.