1 Reply Latest reply: May 15, 2014 10:04 AM by Nick Osdale-Popa RSS

    Summary sorting - Help

    jdino73 _

      I would like to sort a summary by Total sales in descending value however I do not want this to be the first column  , i would like it to be the foruth column


      In the first column i would like Region

      In second column -Location

      In third column Name

      Forth column, Sales (sorted high to low)


      I can only acheive this sort with the total sales in the first column


      Thank you for your help

        • Summary sorting - Help
          Nick Osdale-Popa

          Create another calculated column that is equal to your Total Sales Column.

          Make this new column your first column in your Summary and then the rest of your columns as stated. The new column can be hidden in the properties of the Summary. I believe this feature is available in ver 9 and up.