Hi,
I have YTD monthly data until November with around 250,000 rows on each sheet.
Is it possible to create a pivot table that has the monthly datasets combined in it?
The table i want to create just needs simple sums so the rows in teh table itself should only be up to 10 rows and I dont need to go in depth and splice things further. I tried the pivot wizard and it said there was too much data and stopped. I figured since I didnt need all the rows of data this would be possible, Any such way?
Bookmarks