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 |
Solved! Go to Solution.
Thank you very much.