How to create select distinct from list box selected value....

[#1]

I want to not need to select all other values  and just select onr and get all except that registries and also sum the values for some fiels where multiple same  value exist  one showing total for that sum value .

1

2

3

4

I select 1 and get all records for 2.3.4 and if i have for 2  lets say 3 entries with  value 1,2,3 to show 2 with column value 6

[#2]

I am reading what you posted now,also see what i made that doesn wha ti need but i need to get rid of the extra value shown as they are the same in the first 3 .

Not sure i did ok but at least it show what i need...

I see you got to the same form like me but have same issue like me that it show data and material  same entries,i woudl liek to see white line and just the first lien to have values 1050059  55441  06/05/2014  1000403

[JonnyPoole]

What is the criteria that defines which row to hide ?  I noticed the Lot was '-' so i enabled 'suppress NULL value' as below.  

But I'm not sure that is the right criteria

[#4]

You don t need to supress them as if you do i m thinking the cantitate field that will be sum will not take the value you supress.

I need to supress  like first field has same value for every row  10500059 i need to have one value like in  transare excel exactly like that.

More simple i need  to get from aufm  to transare   .

Like i load aufm and by script of expression in table box or etc to have a result like transare excel

1050059	55441	6/5/2014	1000403	55441	2000050	196.66	13.61	2676.543	15720.22	38.27	-15681.95
					2000131	3.9	56.19	219.141	311.75	1.35	-310.4
					2000199	61.03	17.03	1039.341	4878.5	11.75	-4866.75
					9200003

[JonnyPoole]

OK !  I would suggest using a PIVOT TABLE chart and on the presentation tab select 'always expanded' .  Then the row values won't be repeated

[#6]

Ya but doesn t seem to work if i do it my way .

Will try your way  maybe it work in pivot table ,for me not clear  how to set up pivot table as if i do dimensions the column used for the other i did t it goes bad showing nothing then a material1 field name and no data.

[JonnyPoole]

in a straight table, expand the + on the dimension tab next to 'Command' . In the text color enter:

=if ( RowNo(total) > 1, argb(0,125,125,125))

This will make the text color transparent when the row > 1.  Repeat for the dimension that you like to hide.