jonespandrew
New member
- Joined
- Jan 27, 2016
- Messages
- 122
- Reaction score
- 0
- Points
- 0
Hi i need to know if the following is possible.
1. can you create a custom pivot table without using the pivot table function as the design of the pivot table is a bit restrictive.
2. can you view the data behing the values in a pivot table on the same sheet
3. Can you createa a drop down box linked to the pivot table report filters to do a vlookup and pull data.
I only ask this as I have two pivot tables and uses want to see the Wo numbers that failing and overdue etc in table formate but pivot table does not allow this.
Any Ideas
1. can you create a custom pivot table without using the pivot table function as the design of the pivot table is a bit restrictive.
2. can you view the data behing the values in a pivot table on the same sheet
3. Can you createa a drop down box linked to the pivot table report filters to do a vlookup and pull data.
I only ask this as I have two pivot tables and uses want to see the Wo numbers that failing and overdue etc in table formate but pivot table does not allow this.
Any Ideas