2 Replies Latest reply: May 7, 2013 2:13 PM by Brian Prokop RSS

    Set Analysis

      I  am using the following set analysis formula to return the total of the full set of data:

       

      sum({1} Amount)

       

      How can I modify my formula to return the current selection of the date selected but if any other selections are made I want it to return the full set for any other selection made. I have listed an example table below.

       

      Example:

       

      Data is as follows:

       

      5/1/2013     Active       $100

      5/1/2013     Inactive     $100 

      5/2/2013     Active       $100

      5/2/2013     Inactive     $100 

      Total                              $400

       

      If I select date of 5/1/2013 and select Active with the current formula sum({1} Amount) it returns

       

      5/1/2013     Active       $100

      5/1/2013     Inactive     $100 

      5/2/2013     Active       $100

      5/2/2013     Inactive     $100 

      Total                              $400

       

      I would like to be able to select the date of 5/1/2013 and select Active and return the following:

       

      5/1/2013     Active       $100

      5/1/2013     Inactive     $100

      5/2/2013     Active       $0

      5/2/2013     Inactive     $0

      Total                              $200

       

      This would hold the current selection of the date but show both the Active and Inactive total. Hopefully, this all makes sense.

       

      Thanks

       

      Brian