0 Replies Latest reply: Nov 15, 2016 9:47 AM by Evgeny Stuchalkin RSS

    Pivot table sorting trouble

    Evgeny Stuchalkin

      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}>} [Единиц техники])