7 Replies Latest reply on Nov 19, 2015 4:54 AM by Daniel Vincent

    why is using a filter 'by field' does not show the same values as sort 'by field'?

    Nofar Cohen



      when I use sort: order-descending,'by field' revenue, aggregation sum ,


      i get good sorted values from top to bottom on the grand total of the revenue field

      sort result.PNG

      but when i add to that same field a 'top 10' filter 'by field' revenue, aggregation sum,


      some of the values that originally appeared at the top do not appear any more.

      filter and sort result.PNG



      I have no possible explanation to this, appreciate the help