I have a pivot table that captures 284 columns, and I need to include all of the columns. I have to repeat this weekly, so I would like to find a way to "check off" all of the fields to be included in the pivot table without having to click 284 times, is this possible?
My other option is to use the "Sub Total" function, but I would prefer to use pivot tables if possible since I am more familiar. Even with the Sub Total it looked like I was running into the same issue of having to click every column to be totaled.
Help!
Thanks in advance.
Bookmarks