Hi all,
I am trying to consolidate various ranges of data into one pivot table. Perhaps the best way of demonstrating my conundrum is attached.. whilst I can get the total $ sales associated with each Salesman consolidated, I don't appear to be able to apply the additional filter of 'City' to the PivotTable.. compare to on the right hand side where I list all the data in a single range, I can sort first by city, then by Salesman. Is this a limitation of consolidating data within a pivot table, or am I doing something wrong here?
Apologies as I have had limited experience dealing in the wonders of pivot tables. This certainly looks like a great feature but just not sure whether I have approached this wrong, or whether this is a limitation of the consolidation feature (if so, is there any way to get around this?)
Any help is much appreciated!
Thanks
A
Bookmarks