I need a weekly
(period_ending_date) count of items by category.
The tables/views I need to use for this query are
The “category” grouping is the field
dim_item.mdlz_biz which is in
I only want results starting from 1/1/2018 forward.
vw_pog_delhaize_historical has 3 columns:-
1.storeid 2.itemid 3.period_ending_date
vw_pog_delhaize_historical and dim_item can be joined by