Hello!

I am trying to filter the below code by the subtotal of MEMBERID and PAIDAMT. Can someone advise how to do that? Previously I was doing a complicated match procedure but I feel like this can be A LOT simpler. The WHERE statement is just an example of what I want to accomplish .

SUM
PAIDAMT
BY MEMBERID
BY ETG
WHERE TOTAL PAIDAMT WITH MEMBERID GT 50000

I tried looking throughout the forum and couldn't find anyone trying to do this.

Thanks in advance!!

This message has been edited. Last edited by: Brandon Andrathy,

This could be an option

TABLE FILE CAR
SUM DEALER_COST NOPRINT
BY COUNTRY
WHERE TOTAL DEALER_COST GT 10000;

SUM RETAIL_COST
BY COUNTRY
BY CAR
END
-RUN

Works like a charm! Thanks a lot@!!!