Hello,
My Pivot supports collapsing all rows and sorting them.
However when I change a filter, the pivot is:
-
filtered (as expected)
-
all rows expanded (users need to again configure collapse\expand state)
-
sorting rules are no longer applied (users need to re-sort the column).
This means that for each filter change the user needs to reapply all sort\collapse\expand configurations.
How can I disable this behaviour?