Hello
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?
Thank you.
