I need a weekly (period_ending_date) count of items by category.
The tables/views I need to use for this query are vw_pog_delhaize_historical and dim_item.
The “category” grouping is the field dim_item.mdlz_biz which is in dim_item.
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 itemid column.