2 Replies Latest reply: Jul 25, 2016 12:07 PM by Sunny Talwar RSS

    Calculated Dimension or Set Analysis in a Straight Table

    Cliff Clayman

      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.