Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ID | Sub ID | Price |
---|---|---|
1 | 111 | 1,8 |
112 | 1,4 | |
113 | 2,3 | |
2 | 222 | 1,7 |
223 | 3,4 | |
224 | 1,2 |
ID | Sub ID | Price |
---|---|---|
1 | 113 | 2,3 |
2 | 223 | 3,4 |
How can I obtain this table?
Thanks all.
Hi,
Use Max(Price) to obtain this
Regards,
Anand
Hi,
In
Dimension use ID
Expression Max(Price)
HTH
Regards,
Anand
If I use max Price i obtain the first table, because it give me for each Sub Id the max price. Instead, I want obtain only the sub id with the max price for each ID.