Hello! I have pivot table, with two row dimensions. I'm sorting all dimensions with formula:
sum(${<[Date Type]={'Deal Close'}, Win=-{0}>} [Amount]), by decease.
But order of sorting is broken, as result. I'm find out that it happens because some level-2 dimension values cross with several level-1 dimension values. If i'm select only one level-1 dimension value, sorting works fine.
How to change formula, for sort order respect measure value in current table secion?