5 Replies Latest reply on Aug 20, 2014 2:27 AM by Jan Brooijmans

    How can I create a constant total to use in a table calculation regardless of filter?

    Vito De Filippis

      I have sales data with multiple customer segments and events. I would like to be able to calculate an index which compares the total sales distribution by event to the selected segment (filter) sales distribution by event (for instance, the total sales index would be 100 but when filtered on a strong segment it would be 150). The calculation would be Sum of Sales % / Grand Total Sales % for column * 100

       

      I hope that was clear and not too confusing. I have been searching online and I cannot seem to find any solutions to this.

       

      Has anyone tried to do anything similar to this in the past, and how did you figure it out?

       

      Thanks