Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
How to let a dimension to ignore the filter that control another dimension?
For example, there are 2 tables. In the first table, it contains Type and Items as the dimension. I want to show only 2 Type in this. But for the second table, I want to show the result with different Items. How can I do this? As I change the selection for Items in second table, it will affect the result of the first table.
But I only use the field "Financial Highlight_1..Total Expenditure 2..Recurrent Income(Detail Pop up table).Items" as the row in both tables and do not use any set analysis.
There might be some association between the table from where this two fields are coming. Ensure that you don't have the association and it is a complete isolated table.
Please share the screenshot of data model if nothing helps.