8 Replies Latest reply on Sep 27, 2018 9:37 AM by Edward Ostrovsky

    Weird looking output for multiple columns custom sort

    Edward Ostrovsky

      I have many territories, but for some reason null is the first one showing up.

      I followed the instructions here: http://tableaumonkey.com/2016/01/20/sorting-by-a-field-in-a-secondary-data-set/ on a blended data set, to create applicants_sort = - RUNNING_SUM(SUM([applicants])) and add it to the dashboard (then hide).

       

      It did what it was supposed to, but the output of repeating territory names inside the vertical lines everywhere looks very much off:

      Untitled.png

       

      This is how the data actually looks like if I scroll all the way right (ie. with the wrong sort for territory)- and how I would like the above output to look:

      Untitled2.png

       

      Any idea how I can attain that?