4 Replies Latest reply: Dec 12, 2010 6:10 PM by danhilz RSS

    Set Analysis - Aggregating rows by an ID, then show ID sums over $100K

      Is there a way, using Set Analysis, to aggregate row amounts by an ID, then only show aggregation sums > $99k

      Example:

      Invoice # row Amount

      Invoice Line 1 . 333 75,000
      Invoice Line 2 333 25,000
      Invoice Line 1 334 5,000
      Invoice Line 2 334 1,000

      Results: Invoice 333 100,000