6 Replies Latest reply on Feb 18, 2016 9:10 AM by Shinichiro Murakami

    Control Filter using Parameter

    Akiko Horecka

      I'd like to control Category Filter using Parameter.

      Let's say Parameter has four values (No1, No2, No3, and No4).

      If I choose Parameter.No1, then it gives me the sum of the Count of Category A (30).

      Parameter.No2 gives me the sum Category A and B (60).

      Parameter.No3 give me  the sum of Category C (40).

      Parameter.No4 give me the sum of Category D (110).

       

      How should I write the formula in the Calculated field?

       

      CategoryCount
      A

      10

      A20
      B30
      C40
      D50
      D60

       

      Thank you for your help.

       

      Best regards,

       

      Akiko Horecka