1 Reply Latest reply on Oct 3, 2017 4:54 PM by sunil.sachdeva

    Create a general total while sorting data with a rank function

    Bruno lombard

      Hello to everybody !


      thank you for any assistance you may provide !


      I am using a rank filter to show for instance the top 100 hotels regarding their total of reservations amount for 2017...

      When adding the a general total, it sums the 2000 hotels amounts and not the 100 hotels displayed...


      I would like to sum only the shown datas and not the whole of the datas (included the hidden ones)


      Any idea would be more that welcomed !