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
