Hello! I ahave a pivot table with a lot of dimension.
all of them must be sorted, descending, by expression.
It mostly works fine, but for some dimensions sorting shows strage things (marked with red).
I know it happens because values of this dimension not unique for this level. How i must change sorting expression, to make it works only in current level, not over all levels at same time?
Current expression is:
sum({$<[Тип даты]={'Закрытие сделки'}, Win=-{0}>} [Единиц техники])