3 Replies Latest reply on Dec 3, 2016 6:45 PM by Ankur Gupta

    Changing which field is used for SUM using filter

    Austin Scott

      I thought I could read and find this solution, but I've given up. I've also researched trying to use a parameter to do what I'm asking.

       

      I have two payment fields and I want you to be able to change which payment field is being used in the sheet based on a drop down.

       

      For example, the worksheet sums the "payment amount 1" based on state. I'd like to be able to select "Payment Amount 1" or "Payment Amount 2" and have it dynamically change the payment amount that is found in the marks section SUM("Payment Amount 1") to SUM("Payment Amount 2")

       

      Thanks