2 Replies Latest reply on Mar 22, 2016 11:14 PM by Mahfooj Khan

    Tableau & SSAS - How to sort multiple attributes by measure

    Miljan Radovic

      Hi everyone!

       

      I am trying to create a dashboard using following dimensions / measures from SSAS connection:

       

      Dimension: DimPerson

      Attribute: PersonName (Peter, Jasmine)

       

      Dimension: DimCustomer

      Attribute: CustomerName (Kate, Michael, John, Sarah, Philip)

       

      Measure: ContactCount

       

      I want to show top 5 contacts per ContactCount between person and contact. If I drag PersonName, CustomerName and ContactCount to the dashboard, I get following (default order by person name then contact name):

       

      PersonNameContactNameContactCount
      PeterJohn14
      PeterKate10
      PeterPhilip9
      PeterSarah7
      JasmineKate11
      JasmineMichael4
      JasmineSarah13

       

      Tableau allows me to use either PersonName or ContactName and Sort by 'ContactCount', but then I am getting something like this:

       

      Person NameContact NameContactCount
      PeterJohn14
      PeterKate10
      PeterPhilip9
      PeterSarah7
      JasmineSarah13
      JasmineKate11
      JasmineMichael4

       

      But I want to "break" this artificial hierarchy between Person and Contact and get this result:

       

      Person NameContact NameContactCount
      PeterJohn14
      JasmineSarah13
      JasmineKate11
      PeterKate10
      PeterPhilip

      9