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.
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.
