12 Replies Latest reply on Aug 19, 2016 2:15 AM by Rudranshu Praharaj

    Sorting/Filtering on Dimension and Sub-Dimension

    Oli K

      Hi all,

       

      Please find attached some test data (just 3 columns...) and worksheet to help explain my problem.

       

      AccountSub AccountValue
      A130000
      A230000
      ...(see attached)...

       

      I am trying to

      • sort the accounts by sum of value of all their sub-accounts (easy - even I managed that)
      • sort the sub-accounts of an account by their value (it's not doing what i want - presumably because many accounts have a sub-account with the same name; however there should be no connection between e.g. A-1 and B-1)

       

      Once that's done, I want to

      • show only the top 3 accounts by sum of value of all their sub-accounts (I got this to work until I added sub-accounts)
      • show only the top 3 sub-accounts by value for every account

       

      All this should probably be quite straightforward - can someone please help? :-)


      Thank you!