Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.