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
please note that column name is Number of Stores with zero stock