Pivot table report filters

jonespandrew

New member
Joined
Jan 27, 2016
Messages
122
Reaction score
0
Points
0
[h=2]Data[/h]


Register for a FREE account, and/
or Log in to avoid these ads!


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​
 
Have you tried using the tabular format option for a pivot table? Click in a standard pivot table, and on the Design tab choose Report Layout -> Show in Tabular Form. Then, on the same tab, turn off any subtotals or grand totals that get in the way. You might also want to select Report Layout -> Repeat All Item Labels.
 
What I am trying to do is have it show

Failed Overdue

and under each heading display list of wo but I know a Pivot table can not do that.
 
Back
Top