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

      03d1e2957f.jpg