I have pivot table and an expression containing set analysis: sum({<dim1=,dim2=>}value)
The main reason im using set analysis here is so when a user clicks a cell(expression), the pivot table remains whole and doesn't collapse and shows only the dim w/ values associated with the clicked cell. This is used as a summary table. Also, when a user clicks the cell they are interested in a details table appears that presents all details behind the cell's value.
This is working great.
The issue arises when a user selects another cell from the summary table that is different from the first selection (if the same cell is clicked twice, the details table disappears and so do the filters, which is expected). When an adjacent cell is selected some of the filters are removed.
Week1
Week2
Week3
dim1
value1
value3
value5
dim2
value2
value4
value6
So if value1 is selected, the filters will be dim1, week1, perfect as expected. From here if dim1, week2 is selected dim1 will be removed from the filter, not good as the details table will show all data for week2.
Is there a way to leave each filter intact with every cell selection?
