When any of the following actions is performed, all
existing sorts, filters, and ranks that are applied to that axis (the "target"
axis) are automatically removed:
Swapping dimensions, removing a dimension, or
adding a dimension.
Changing the order of nested dimensions.
Swapping a dimension to the slice axis.
Swapping the positions of the row and column
dimensions with the Swap Axis button does not remove sorts, filters, or ranks
from the query.