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

      Hi,

       

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

      sort.PNG

      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,

      filter.PNG

      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

      Thanks