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]

in your expression write like this

sum({<TRANSTYPE={5}>}cost)

or please post your sample app. make it easy to clarify your ques

[senpradip007]

try this in expression:

Sum({<TRANSTYPE = {5}>}INVENT_QTY)

and

Sum({<TRANSTYPE = {5}>}Cost)

Hope it helps you.

Regards

PS

[ecabanas]

Hi PS

Thank's for your answer, but I want to see all the lines, not the sum.

This is a Scarp report, and there are two tables, one with the "SUM" and the other is the complete list of scrap units.

many thank's

[#5]

Can you post your sample

[#6]

PFA

[senpradip007]

As per my understanding you want the line which contains TRANSTYPE = 5 without any sum.

[Gysbert_Wassenaar]

You can select transtype 5 in a table box as well.

But if you want to hardcode the selection (not recommended) you need a straight table with at least one expression. For example sum({<TRANSTYPE={5}>} Cost).

[ecabanas]

Hi,

here you have an example

[senpradip007]

Hi Edu.

You can't this features in Tablebox. To achieve this you have to go with straight table.