3 Replies Latest reply on Feb 13, 2012 4:18 AM by Shawn Wallwork

    How do i filter columns based on multiple selections and use only the selected columns in a calculated field?

    Archana Amarnath


      I have attached a sample of the data i am working with.

      The data has Sales info for 10 departments for different regions (A-T).

      The Columns RS1-RS23 represent the discount amount for each Department and Region for that particular reason (RS)

      I will need a multiple select filter for reason selection.


      Based on the reason selected (eg. RS1 and RS2) i need to calculate the discount %: sum( RS1 + RS2)/ Region Sales


      I had tried to use a parameter to filter based on selected columns, but in parameters there is no multiple select option. Need help with this.