Hi everyone, I’m new to the whole pivot tables and have so far fallen in love with their usefulness however I’m trying to figure out a way to visualize loads of information from different files (each customer has one file, and there are 30) in one Pivot Table. The issue is that, even if the information is presented in the same style, the columns fields are not always the same.
Ultimately the goal if to be able to set one pivot which uses the “page” field as a filter to view the information from each different customer. I know this might be a bit confusing so I’m attaching a file for you guys to take a look and give me your thoughts on it. I mean, is it even possible or will I have to create 30 different Pivot tables. Additionally is there a way to have several Pivots in a file and use a filtering device to view one at a time?
Thank you all for your time, any help will be extremely appreciated…
Cheers,
Kianuz
Bookmarks