5 Replies Latest reply on Oct 7, 2015 7:08 AM by Rody Zakovich

    Sorting columns by count given a filter imposed by a page

    Dror Atariah

      I have the following data set:

        

      CatCountryCount
      ADE0.4596065657
      BDE0
      CUS0.3224789091
      AUK0.4740651803
      BUS5
      CUK0.6467712916
      AUK0.4206986968
      BDE0.647481787
      CUK0.7009353881
      ADE7
      BDE0.7069499038
      CUS0.533527981
      AUK0.4508682048
      BDE0.8765276942
      CUK0.051035432
      ADE0.2925312932
      BUS0.801152562
      CUK15

       

      In Tableau I linked to this set and started a sheet:

      "Country" -> "Columns

      "SUM(Count) -> "Rows"


      If I (descending) order the countries by the count I get three vertical bars ordered "UK", "DE" and "US".


      So far so good. Next, I add a new sheet, duplicating the previous one, and adding the "Cat" pill to the "Pages" shelf.


      Now, I get three views (one for each category). For each category I see all countries, even if its count is zero (e.g. "US" in cat "A").

       

      First question: How can I hide the "empty" columns?

       

      Second problem, and even more disturbing, is that I cannot find a way to correctly order the countries by their counts for a fixed "Page"/"Cat". In particular, the order is always "UK", "DE" and "US", even if for cat "B" the "US" had more counts than "DE".

       

      Second question: How can I sort the columns for each page independently?