Hello Guys
I am having the problem in summarising the data (multidimensional). I have been asked to create a report by region, brand and feature according to month, quarter and year.
I am attaching the spreadsheet for the reference.
This report cannot be made by using Pivot Table/chart.
This has to be thru using formulas.
I am trying to use Vlookups but some how I cannot figure out how to consolidate or summarise Period(Months, Quarterly or yearly).
If anyone can please help me with this would be very helpful to me.
Appreciate of help in advance.
Thanks
AV
Bookmarks