3 Replies Latest reply on Jan 5, 2017 1:51 AM by Norbert Maijoor

    Top N sorting HELP

    Mikey Michaels

           Hello All and Happy New Year!

      I have a quick question I hope someone will be able to help with.

       

      On the attached, I trying to show the Top N Global DUNS based off my measure "Sum Seats". The Global DUNS that are contained in the Top N are labeled "In" using my "Group In Out" calculation, and those that are not in the Top N are summed in the "OUT" line.The date or time period I'm using is a table calculation on the columns shelf called "Select Date Level (1)".

       

      I want to be able to sort each "date level" (e.g. 2015012, 2015011) in descending order individually. Can someone please help?

       

      Cheers,

      Mikey