1 Reply Latest reply on Oct 15, 2018 9:45 AM by Ken Flerlage

    Sorted charts with multiple variable

    Utkarsh Srivastava

      Hi,

       

      I am working with the following data :

       

       

       

      MonthTypeCategory 1 SumCategory 2 SumCategory 3 Sum
      Apra94083
      Aprb5090
      Aprc7202
      Aprd61091
      Apre10122
      Maya85028
      Mayb93128
      Mayc48196
      Mayd20124
      Maye9515
      Junea44051
      Juneb11119
      Junec73115
      Juned4071
      Junee780

      77

      I need to set up the following graph as in Excel  and sorted by Month then Type (Descending sum of category 3)

       

       

      But replicating this in Tableau , I unable to get it properly. What is the best way of doing it?

       

      I tried to create third variable to sort it properly but then I see the dots.

       

      Either I can get it proper line or correct sort .

       

      Any help would be appreciated.

       

      Harry