eechristaylor
New Member
- Joined
- Oct 22, 2013
- Messages
- 43
- Office Version
- 365
- Platform
- Windows
I have the below pivot by sections.
When i select the Grand totals at the bottom of the column, say for section one I select "39" and it should return just section one comments across 39 records. It does not it returns all records from the source of the PIVOT data so then I have to clean it up to get just the section 1 comments. This is the same for each section.
What do i need to do to get this to just return the worksheet with just the Section 1 comments and only 39 records?
When i select the Grand totals at the bottom of the column, say for section one I select "39" and it should return just section one comments across 39 records. It does not it returns all records from the source of the PIVOT data so then I have to clean it up to get just the section 1 comments. This is the same for each section.
What do i need to do to get this to just return the worksheet with just the Section 1 comments and only 39 records?