3 Replies Latest reply on Mar 31, 2016 1:41 PM by emmanuel.owusu

    Top 10 by Grand Total (Cube)

    Taze Young

      Hi folks,

      I have data from a cube.

      Simple stuff, but for some reason I can't do a top N by grand total properly.

      See 1.jpg where it's sorted by Grand total - note the value Window's XP

      But once I do a Top 10 by filtering, anything with nulls is excluded (2.jpg)...even though I've already converted nulls to zero.

       

      Any ideas?

       

      Thanks all.