Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, In my data source i have a table like below,
ID | Cell | Traffic GB |
1178 | 1 | 0.0 |
1178 | 2 | 0.0 |
1178 | 3 | 0.1 |
1178 | 4 | 0.1 |
1178 | 5 | 0.5 |
1178 | 6 | 0.7 |
1178 | 7 | 0.9 |
1178 | 8 | 3.2 |
35536 | 1 | 0.0 |
35536 | 2 | 0.0 |
35536 | 3 | 0.1 |
35536 | 4 | 0.1 |
35536 | 5 | 0.1 |
35536 | 6 | 0.1 |
35536 | 7 | 0.3 |
35536 | 8 | 0.3 |
35536 | 9 | 0.3 |
35536 | 10 | 2.6 |
my objective is to get the max value for each ID with its corresponding cell as shown in the table like below,
ID | Cell | Traffic GB |
1178 | 8 | 3.2 |
35536 | 10 | 2.6 |
any idea please
Hi @EngMaher88 !
It's very easy to do.
Column 1: ID
Column 2: Max(Cell)
Column 3: Max([Traffic GB])