How to show a table(not pivot) with certain data

[ecabanas]

Hi I have the follong data in a table chart:

ITEMID	ITEMNAME	DATEFINANCIAL_LINE	INVENTTRANSID	TRANSTYPE	INVENT_QTY	Cost
10361283	TRINCHADO DE CARLIT DE LA CERDAÑA	02/01/2014	00981599_103	0	-1	-2,27
10361283	TRINCHADO DE CARLIT DE LA CERDAÑA	08/01/2014	00994254_103	5	-5	-11,35
10361283	TRINCHADO DE CARLIT DE LA CERDAÑA	10/01/2014	00995839_103	3	6	13,62
10361283	TRINCHADO DE CARLIT DE LA CERDAÑA	18/01/2014	01017648_103	0	-1	-2,27
10361283	TRINCHADO DE CARLIT DE LA CERDAÑA	27/01/2014	01036417_103	5	-5	-11,35
10361283	TRINCHADO DE CARLIT DE LA CERDAÑA	28/01/2014	01038177_103	3	6	13,62

But I only want to show the lines with TRANSTYPE = 5

I can not use a list box  🙂

Many thank's

Eduard

[#2]

Hi Eduard.. What is Mr Pradip said its right there is no option in table box better you go to straight table

[#3 · Accepted solution]

Hi

PFA hope this will helps you

[ecabanas]

Hi guys,

Yes I understand, but with the example returned by Pradip in the straight table you do a SUM, but i need a list of transactions with TRANSTYPE 5, not a SUM!!! I need a table with the summation and other table explaining what is this summation.

Many many thank's guys

[ecabanas]

WOW!!!!! Applause!!!!!

Many thank's Nirmal, and many thank's all guys!!!

[Gysbert_Wassenaar]

That doesn't matter as long as you add all the dimensions that make the record unique to the straight table. You'll get a sum of an individual record. sum(10) will still be 10.