6 Replies Latest reply on Oct 1, 2018 11:20 AM by Janice Ip

    How to sort top N with Filter Formula base on a different variable.

    Janice Ip

      So I have a parameter that already filter Nationality (International and National)

      This is an example of how my data is organized 

      Nationality Date Location of origin District Unique Count
      InternationalJan-18USANorth3502
      InternationalJan-18USANorth3824
      InternationalJan-18USASouth5652
      InternationalJan-18EURSouth5855
      InternationalFeb-18USANorth3150
      InternationalFeb-18EURNorth4041
      InternationalFeb-18CHNSouth5776
      InternationalFeb-18CHNSouth2125
      InternationalMar-18USANorth2677
      InternationalMar-18CHNNorth4598
      InternationalMar-18EURSouth4667
      InternationalMar-18CHNSouth5943
      InternationalApr-18USANorth4519
      InternationalApr-18CHNNorth4074
      InternationalApr-18EURSouth2421
      InternationalApr-18CHNSouth2725
      NationalJan-18BCNorth1611
      NationalJan-18ONNorth2850
      NationalJan-18BCSouth2008
      NationalJan-18ONSouth2745
      NationalFeb-18ONNorth1443
      NationalFeb-18ABNorth2651
      NationalFeb-18ABSouth1597
      NationalFeb-18BCSouth2327
      NationalMar-18ONNorth1998
      NationalMar-18ABNorth2670
      NationalMar-18ABSouth2148
      NationalMar-18ONSouth2057
      NationalApr-18ABNorth2658
      NationalApr-18ONNorth1863
      NationalApr-18BCSouth1272
      NationalApr-18ONSouth1478

       

      The problem I have with sorting with top in the filter menu is menu can't read the Numbers from International because the count from International are much lower than Nationals

      And tableau is reading the data only from location of origin so it is not sorting International and National individually.