Help needed

[#1]

Dear all

I have data like this

trnType	DocNo.	Date	Party	Product	Qty.	Amount
Sales	INV/001	01/04/2011	XYZ & Co.	Product 1	50	500
Sales	INV/002	02/04/2011	ABC & Co.	Product 2	100	1000
Return	RET/001	01/04/2011	XYZ & co.	Product 1	10	100
Return	RET/002	02/04/2011	ABC & Co.	Product 2	10	100

In a straight table chart I want to show only Sales data and in anotherI want to show Return data, How I don't know.

Please Help me.

anil

[swuehl]

One way would be to use a calculated dimension like

=if(tmType = 'Sales', tmType)

and suppress NULL on dimensions. Similar for Return type.

Another way would be using set analysis in the expressions, like

sum({<tmType = {'Sales'}>} Amount)

Similar for all other expressions.

Hope this helps,

Stefan