All of the YouTube videos that I've seen on grouping data in a pivot table don't have that many records, what a dozen at the most?
Here I have a pivot table with 344 lines, that needs grouping.
I had to reach out to the client to ask which of the 344 payees were subcontractors, and it would come to me in pieces; different emails identifying the subcontractors a few at a time.
So, I had to add items to the group as they came in from the client.
This was the most difficult task in dealing with this data set.
I want to ask the Group following questions:
1. Is there a simpler way to select the items/lines as they were not conveniently available on the screen (some were dozens, if not hundreds of lines apart)
2. a way to sort the group (I wanted the phrase Subcontractors to come before Vendors)
3. is there a simpler way to add/remove brackets from the Group
Bookmarks