4 Replies Latest reply: Nov 1, 2016 9:30 PM by Sunny Talwar RSS

    Need help with sorting using expression

    Vijayanth radha

      I have ONE chart with variable dimension and corresponding counts. Based on a variable this chart will show counts for (Sex) or (Insurance)

       

      If variable 1 is selected, the chart will be as follows: Note: (Sorting is based on ascending order of Sex column)

      Sex            Count

      Female      12

      Male          24

      Unknown   2

      Total          38

       

       

      If variable 2 is selected, the chart will be as follows: Note: (Sorting is based on Descending order of Count)

      Insurance          Count

      Insurance 2       20

      Insurance 1       11

      Insurance 3       7

      Total                 38


      Please help me accomplish this using expression