Forum Discussion

Juan_Moreno's avatar
Juan_Moreno
Copper Contributor
Jan 10, 2024
Solved

Help with Pivot Tables

Hello, I have an issue. I'm using Excel in the web version, and I was asked to link two sheets. The first sheet retrieves its data from the second sheet, which contains the data in a pivot table. The...
BI & Data Analysis
excel
Excel for web
Formulas and Functions
office 365
  • Lorenzo's avatar
    Lorenzo
    Jan 11, 2024

    Hello Juan_Moreno 

     

    Corresponding sample shared https://1drv.ms/x/s!AsuqEFbTJNgcgaY9SWRu1asDLBzxCA?e=yBIJSE:

     

    As you can see above in the source of my PivotTable the values are in column [Value]

    So, with the PivotTable in B4 in sheet 'PivotTable' the formula in C4 is:

     

    =IFERROR(
  GETPIVOTDATA("Value", PivotTable!$B$4, "CODIGO", [@CODIGO]),
  "Not found"
)

     

    or if you prefer:

     

    =IFERROR(
  GETPIVOTDATA("Value", PivotTable!$B$4, "CODIGO", B4),
  "Not found"
)

     

Lorenzo's avatar
Lorenzo
Silver Contributor
Jan 11, 2024

Hello Juan_Moreno 

 

Corresponding sample shared https://1drv.ms/x/s!AsuqEFbTJNgcgaY9SWRu1asDLBzxCA?e=yBIJSE:

 

As you can see above in the source of my PivotTable the values are in column [Value]

So, with the PivotTable in B4 in sheet 'PivotTable' the formula in C4 is:

 

=IFERROR(
  GETPIVOTDATA("Value", PivotTable!$B$4, "CODIGO", [@CODIGO]),
  "Not found"
)

 

or if you prefer:

 

=IFERROR(
  GETPIVOTDATA("Value", PivotTable!$B$4, "CODIGO", B4),
  "Not found"
)

 

  • tina172003's avatar
    tina172003
    Copper Contributor
    Jan 13, 2024

    pruduct activation failedLorenzo 

    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Jan 13, 2024

      You're welcome Juan_Moreno.

      Next time(s) don't forget to Mark as response (link at the bottom of each reply your get here) - This helps people who Search. Thanks

Resources