Forum Discussion

Marco_Sabau's avatar
Marco_Sabau
Copper Contributor
May 09, 2023

Calculated field in pivot table referencing table in another sheet

Hi, I have a question regarding calculated fields in a pivot table. I have a 8 column table in a sheet that I used to make a pivot table in another sheet. I want to add a field that is the condit...
excel
Formulas and Functions
  • Martin_Weiss's avatar
    Martin_Weiss
    May 11, 2023

    Hi Marco_Sabau 

     

    if I understood correctly, you wanted to add your formulas to a calculated field in a pivot table?

     

    Unfortunately, that's not possible. In a calculated field of a pivot table, you cannot refer to a cell or a cell range of your workbook. Also, you can use only very basic arithmetic calculations like + - / * or functions that do not refer to a cell or a range of the workbook.

     

Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
May 11, 2023

Hi Marco_Sabau 

 

if I understood correctly, you wanted to add your formulas to a calculated field in a pivot table?

 

Unfortunately, that's not possible. In a calculated field of a pivot table, you cannot refer to a cell or a cell range of your workbook. Also, you can use only very basic arithmetic calculations like + - / * or functions that do not refer to a cell or a range of the workbook.