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 !

       

      Bruno