I am using a table to display different dimensions. However, Table only allows single dimension. Hence, I have added all the necessary dimensions through if..else.
Below is the expression for the table dimension where there are 3 dimensions A, B and C. Each of them are calculated based on different conditional data.
Now, I would like D1 to ignore any filters on Field3. However this should not impact D1 or D3. My question really is how to limit the scope of data within if conditions?
Hope this helps.