Pivot Table Sorting

[#1]

Hi,

Has anyone figured this out yet? How to sort a pivot table at an expression level in context of a table row. I have a simple pivot table attached and would like to sort each store by its category quantities.

[Gysbert_Wassenaar]

You can't sort one dimension in two ways. So sorting by expression won't work afaik. You can use a straight table or add a calculated dimension to the pivot table and sort by that calculated dimension. You could also sort the Store dimension by Y-value, but that will not only sort the category dimension, but the Store dimension as well.