How to show rows only have top values?

[#1]

Hi,

I have data as below. How to get the table in qvw only to show rows which is Max(No)

for eg:

considering below sample data I need to show output only the row

S908779       US          11/06/2013       20         19038                 56                     64563

ID	Region	DateManufacture	No	Kety	Moniyt	Notax
S908766	US	11/03/2013	20		0
S908767	US	11/03/2013	10	461	461
S908768	US	11/03/2013	8		461
S908769	US	01/04/2013	1	461	461
S908770	US	11/04/2013	10	461	461
S908771	US	11/04/2013	8	510	461
S908772	US	11/04/2013	20	345	355	23423
S908773	US	01/05/2013	1	461	461
S908774	US	11/05/2013	8	510	461
S908775	US	11/05/2013	10	461	461
S908776	US	11/05/2013	20	345	34	5534
S908777	US	01/06/2013	1	461	461
S908778	US	11/06/2013	10	461	461
S908779	US	11/06/2013	20	19038	56	64563
S908780	US	11/06/2013	8	510	461
S908781	US	01/07/2013	1	461	461
S908782	US	11/07/2013	10	461	461
S908783	US	11/07/2013	13	510	461
S908784	US	11/07/2013	8		461
S908785	US	11/07/2013	20	24	56	5465
S908786	US	01/08/2013	1	461	461
S908787	US	11/08/2013	10	461	461

Can anyone suggest me please.

Thanks.

[#2]

Please help me. please . I am really struggling !

[timanshu]

Hi,

for id Rt0976, table is showing 39 rows and  same you require then what is issue?

[#4]

no it s not working.

[MK_QSL · Accepted solution]

Create a Straight Table....

Use Dimension Fields DateManufacture, Kety, Moniyt, Notax, Region, ID

Expression

IF(No = Max(TOTAL <ID> No), No)

Go to Presentation Tab

Tick Suppress Zero Values

Hope this would work.. !

[#6]

Thanks very much. I used this.The user started working on this file. will update you once I heard from user.

[#7]

user confirmed 100%. Super!. This exactly worked!