I'm using Excel2010. I have a pivot table that has top level fields and lower level fields. The lower level fields are sometimes the same name as the top level. When I try to expand in a particular spot, it expands the same name in the other top level field. Example:
I have Location1 and Location2 as top level
The next level is Finished Goods, Raw, Bulk etc.
If I want to expand "Raw" in location2 it expands in both location1 and location2. Is there an option to stop this?
Thanks
I have Location1 and Location2 as top level
The next level is Finished Goods, Raw, Bulk etc.
If I want to expand "Raw" in location2 it expands in both location1 and location2. Is there an option to stop this?
Thanks