Hi, I've been playing around with Pivot tables in an attempt to learn them. Already finding them very useful. I have a large spreadsheet that has a format of something like this.
Spreadsheet.PNG
I create a Pivot and filter by the locations like this.
Filter.PNG
It works but I have 4 filters (even more with my real spreadsheet that has 30 locations) Is there a way to merge these locations into one filter. Say a top level like Location and then be able to dig down each level from there?
Example
Location
- North
A- South
B- East
A- West
B
Hope that makes sense. Been googling but can't find any way to do that. If it's even possible would appreciate if someone could point me into the right direction as to what I should be researching to achieve this.
Bookmarks