5 Replies Latest reply on Aug 1, 2018 3:02 PM by Peter Fakan

    How to filter only one parameter on the visualization

    Suhas Chauhan

      I want to filter only one of the parameter in the attached visualization ie "is churn final" .( PARAMETERS - is churn final and amount paid)

      Would like to keep the "amount paid" [sum(amount paid) ](which should show total amount paid per quarter irrespective of any filter ) to be constant value in the visualization.

       

      Currently when i filter "is churn final" as No or Yes

      the parameter "amount paid " considers the sum of rows which has a value No and Yes respectively.

       

      Is there a solution for this ? Kindly help

      Attached is the workbook.

       

      Thank You