I have a straight table with 3 fields. FullName, Purchase and PurchaseAmount. I need to Sum the Purchase and PurchaseAmount fields. I then would like to apply a condition on each field before I display the results. I would only like to see the results where the Sum(Purchase) < 5 AND where the Sum(PurchaseAmount) < 1000.
I have tried using Set Analysis and Calculated Dimensions, but I can't seem to get either way to work. I've attached some sample data if anyone can please provide a solution.