Forum Discussion
get a row label from pivot table
Hi all! I have a pivot table and I would like to get some information. For Example the green sqare. When I close the pivot table the text will change...
What do you mean by "close the pivot table"?
HansVogelaar The dropdown menu in the pivot table. In the example from Xia
That's how GETPIVOTDATA works. If you don't want that, it's better to use SUMIFS based on the source data. Enter A and B in M3 and M4.
Then enter the formula
=SUMIFS($E$2:$E$9,$A$2:$A$9,N$1,$C$2:$C$9,$M3,$D$2:$D$9,$M$2)and copy or fill to the other cells. See the attached version.
- Thank you for your reply.
But I need Xia and A and B from the pivot and now you typed it so it is not dynamic...In that case, I'd create a second pivot table with Werkzaam as filter field. See the new version.