Hello!
Could anyone help me? I'm trying to consolidate data from every month into one pivot table, it is basically the name of the person and it should detect if the sale was rev or nr and make the sum, it works great when I do it for just one month but when I use the multiple consolidation ranges what I get is in the last sheet of the file I attached. I tried moving the data from Row into Column and vice versa but still can get it to show totals by year and hopefully disclose it by month too.
help please!
Bookmarks