Forum Discussion

omdl2020's avatar
omdl2020
Copper Contributor
Nov 13, 2020

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...    
Formulas and Functions
  • omdl2020's avatar
    omdl2020
    Copper Contributor
    Nov 13, 2020

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

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Nov 13, 2020

      omdl2020 

      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.

       

      • omdl2020's avatar
        omdl2020
        Copper Contributor
        Nov 13, 2020
        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...

Resources