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.

       

       

      508bf58874.jpg

      How to change formula, for sort order respect measure value in current table secion?