Negative Item List

[ajithsachin]

Hi All,

i want to show the customer wise product list for a month where there is no sales for the items.

Below i am adding a example to make it understand.

ITEM MASTER
ITEMCODE	ITEMNAME
ITEM1	XYZ
ITEM2	ABC
ITEM3	DEF
ITEM4	GHI

SALES DETAILS
CUSTOMER	ITEMCODE	DATE	SALESQTY
CUST1	ITEM1	01-04-2015	10
CUST1	ITEM2	01-04-2015	15

Result should be

NEGATIVE ITEM LIST
CUSTOMER	ITEMCODE	ITEMNAME
CUST1	ITEM3	DEF
CUST1	ITEM4	GHI

Can anybody help please.

Regards,

Ajith

[swuehl · Accepted solution]

If you have a CUSTOMER selected, create a straight table chart with dimension ITEMCODE

and two expressions:

=Only({1<ITEMCODE = e() >} ITEMNAME)

='($=CUSTOMER)'

Drag the columns where you like.