Forum Discussion
Pivot Table
After clicking anywhere in the pivot table, I activated the Design tab of the ribbon.
In the Layout group, I selected Show in Tabular Form from the Report Layout drop-down.
After clicking anywhere in the pivot table, I activated the Design tab of the ribbon.
In the Layout group, I selected Show in Tabular Form from the Report Layout drop-down.
And here is with GETPIVOTDATA (see column AM)
- Perfect, thank you.
In C11 on the Audit Sheet:
=INDEX('Work Tickets'!$F$3:$CA$3261,MATCH($G$3,'Work Tickets'!$B$3:$B$3261,0),MATCH(B11,'Work Tickets'!$F$2:$CA$2,0))
You can fill this down to C14, and copy it to J11:J14, C19:C23, J19:J23, C27:C30 and J27:J30.
But you'll have to adjust the formula for the next employee - the layout of the Audit Sheet makes it difficult to generalize it.
I have tried each of your suggestions and I can't get them to work. I have attached my spreadsheet so maybe you can help me. Also, if there is an easy way to auto fill the rest of the spreadsheet, that would be awesome. We only need what is in the light redish color changed to the new data source which is in the same tab. You can connect it to the data or the pivot table, whichever is easier.
=VLOOKUP($T$4&S5,CHOOSE({1,2},$B$2:$B$401360&$C$2:$C$401360,$D$2:$D$401360),2,0)An alternative could be this formula.
Alternatively that could be
=GETPIVOTDATA("Points",$M$4,"OP #",$T$4,"Pivot table date",$S5)The only it works only if the field is expanded.
To be more flexible it's better to build data model PivotTable.
In T5:
=INDEX($D$2:$D$401360, MATCH(1, ($B$2:$B$401360=T$4)*($C$2:$C$401360=S5), 0))
This can be filled down, and copied to column W.
HansVogelaar I was hoping you could help me one more time. I am wanting to know how many points an OP# did on any given day. I have a master sheet set up that can view 1 at time when I put in their OP#.
- Perfect. Thank you so much for your help.
