get a row label from pivot table

Question

Hi all!&nbsp;I have a pivot table and I would like to get some information.&nbsp;For Example the green sqare.When I close the pivot table the text will change...&nbsp;&nbsp;

hansvogelaar · Answer

omdl2020&nbsp;
What do you mean by "close the pivot table"?

omdl2020 · Answer

HansVogelaar&nbsp;The dropdown menu in the pivot table. In the example from Xia

hansvogelaar · Answer

omdl2020&nbsp;
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.
&nbsp;

omdl2020 · Answer

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...

hansvogelaar · Answer

omdl2020&nbsp;
In that case, I'd create a second pivot table with Werkzaam as filter field. See the new version.

Forum Discussion

get a row label from pivot table

9 Replies

Resources