Hi,
I work in the modern trade channel and needed a help for this.there is a customer sales database that we have.
Customer Name Product Category Unique SKU Desc
Tesco Fruit Drinks Apple juice 250 ml
and the month wise sales data follows.
I have this data across 20 customer names and for 200 unique skus.
If I choose the month as July 2017 I want the L3M ( last three months) namely June,May, April of 2017 to be averaged and displayed and LY( last year same mntH) July 2016 data to be displayed for the category chosen.
Is there any formula or an excel macro that can help me do this? Thanks in advance.
If needed aI can share a sample excel dump as well
Regards
Bookmarks