Hi guys, I need your help on building an overview table based on the existing pivot. My example is attached. I have a PIVOT table with different type of costs, some of which are related to a brand (e.g. XXX, LLL). There's also a key Y/N if it is brand related in the next column. These costs are also organized per month - 3,4,5 (which stands for March - May). I need to create another overview on the next excel sheets which summarizes only brand related costs per month + accruals. Can you please help out?
Bookmarks