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?