Stores With Zero Sales

[barrysaab]

hello,

Item table:

Item_key
item_desc
brand_code
category _code
category_desc
item_number
vendor_key
--------------------------------------------
Date

date_key
cal_date
month name
month_short_name
cal_month
cal_year
cal_quater
days_- in_the _year

-----------------------------
F_sales

sales_key
customer_key




----------------------------------------------------------------------------------------------------------------------------
I have list report with following Category   Sku   Description   Supplier   Sales volume   Sales Value   %Margin   SR Margin   Stock on hand      Stock on order   Number of Stores with zero stock
                        Stores   DC's      




As you see my last column is stores with zero sales,how can i show this value.Please help.Thanks

[barrysaab]

please note that column name is  Number of Stores with zero stock