How to find items zero sales against week number

[Biju]

I need to get the zero sales week Number from the given data based on shipment date.More specifically need to get store wise details suchs as which is having zero sales for a particular item for the week.Attached sample data .Expecting some ones help.

Itemno	Store	Trackingno	DELSTATUS	ShipDate	TransQty	WSPrice	totalcost	OpenOrders	INVTRXTYPE	WeekNum
1	1235		CONSUMER SALES	10/20/2017	-1	2.55	-2.84333	0	SHIP	42
1	1304		CONSUMER SALES	10/20/2017	-1	2.55	-2.84333	0	SHIP	42
1	665		CONSUMER SALES	10/20/2017	-1	2.55	-2.84333	0	SHIP	42
1	890		CONSUMER SALES	10/20/2017	-1	2.55	-2.84333	0	SHIP	42
2	1100		CONSUMER SALES	10/20/2017	-2	2.55	-5.68665	0	SHIP	42
2	2019		CONSUMER SALES	6/20/2017	-1	2.55	-2.84333	0	SHIP	25
2	2050		CONSUMER SALES	10/20/2017	-1	2.55	-2.84333	0	SHIP	42
2	2227		CONSUMER SALES	8/20/2017	-2	2.55	-5.68665	0	SHIP	34
2	993		CONSUMER SALES	10/20/2017	-2	2.55	-5.68665	0	SHIP	42
3	356		CONSUMER SALES	10/20/2017	-7	2.55	-19.9033	0	SHIP	42
4	828		CONSUMER SALES	10/20/2017	-3	2.55	-8.52998	0	SHIP	42
4	1158		CONSUMER SALES	10/20/2017	-3	2.55	-8.52998	0	SHIP	42
4	1685		CONSUMER SALES	7/20/2017	-1	2.55	-2.84333	0	SHIP	29
5	1937		CONSUMER SALES	10/15/2017	-1	2.55	-2.84333	0	SHIP	42
5	1950		CONSUMER SALES	11/20/2017	-1	2.55	-2.84333	0	SHIP	47
5	2244		CONSUMER SALES	10/20/2017	-4	2.55	-11.3733	0	SHIP	42
5	2741		CONSUMER SALES	10/1/2017	-2	2.55	-5.68665	0	SHIP	40

[sgsukumaran]

I  agree with  op about filter . Else you can create a calulated flag column to determine the logic and apply an visual filter

[v-sihou-msft]

@Biju

What's your expected reuslt? 

If you just need to render those "Item*Store" entries against Week Number, you just need to create a Sales measure. Then apply it into Visual Level Filter and make it greater than 0. 

Regards,