1 Reply Latest reply on Aug 25, 2014 10:22 PM by Prashant Sharma

    Adding category distorts sorting

    leo k

      I have a worksheet that looks like this (sorry about the screenshot, this is all I can do at the moment):

      no_cat.PNG

      I have a Business Number (BN) and an amount. What I want to do is to sort by amount. This works fine with this set-up.

      But then I add a category to the rows, now I get a result like this:

      cat.PNG

      BN 767 is now in the wrong position. I know that overall it belongs in that postion, but not when when you add a Category.

      So what I want to do is to sort each category and BN by amount.

      Why does this happen and how can I fix it.

       

      Thank you