Pulling records based on Max ID

[MROGK]

I would like to get the Sales & Profit data ONLY for max Record ID & max Cycle ID. Can someone help? Thank you

RECORD ID	CYCLE ID	SALES $	PROFIT$
1	8	30	10
2	10	45	23
3	8	56	34
1	11	23	11
2	8	31	12
3	10	67	45
1	11	89	34
2	8	34	12
3	10	23	11
1	11	12	8
2	10	78	56
3	8	90	78

[MROGK]

I would like to get the Sales & Profit data ONLY for max Record ID & max Cycle ID. Can someone help? Thank you

RECORD ID	CYCLE ID	SALES $	PROFIT$
1	8	30	10
2	10	45	23
3	8	56	34
1	11	23	11
2	8	31	12
3	10	67	45
1	11	89	34
2	8	34	12
3	10	23	11
1	11	12	8
2	10	78	56
3	8	90	78

[BrandonB · Accepted solution]

Is this what you are looking for?

 

[MROGK]

Thank you very much.