table with max value

[#1]

Hi all,

I need help. I have this table:

ID	Sub ID	Price
1	111	1,8
	112	1,4
	113	2,3
2	222	1,7
	223	3,4
	224	1,2

And I want to create a table that visualize only the Sub ID with the max price. Eg:

ID	Sub ID	Price
1	113	2,3
2	223	3,4

How can I obtain this table?

Thanks all.

[its_anandrjs]

Hi,

Use Max(Price) to obtain this

Regards,

Anand

[its_anandrjs]

Hi,

In

     Dimension use ID

     Expression Max(Price)

HTH

Regards,

Anand

[#4]

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.