I have a large pivot table with multiple row fields and what I am trying to do is return the number of "Locations" under a given "Model". Is this possible in VBA?
Using the picture below as a reference, I would want to return 4 for Armani Ex and 8 for Burberry.
pivottable.jpg
Thank you!
Bookmarks