0 Replies Latest reply: Sep 22, 2016 4:00 PM by Evgeny Stuchalkin RSS

    Pivot Table Sorting

    Evgeny Stuchalkin

      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?