# Is there a way to create a calculated field using results of another calculated field?

Is it possible to use the results of a calculated field as part of a new calculated field? I know further calculation could be done outside the pivot table but I was hoping there was a way to somehow do this within the pivot table.

• can you share a copy of your sheet with an example of the desired output? Commented May 16, 2019 at 17:22
• On the sheet, I want to take the calculated field "Weekly Budget (Col E) and subtract from it the spreadsheet field "Current Week's Spend (Col D) Commented May 16, 2019 at 19:45
• sheet is private Commented May 16, 2019 at 19:46
• np, in your sheet do: i.sstatic.net/OTFcv.png Commented May 16, 2019 at 21:25

Accessing the values of one calculated field in another such field from the Pivot Table menu doesn't seem possible.

Here are two facts that were encouraging, but I suspect are dead ends:

• Access columns from the origin sheet of your pivot table via their header values;
• There is a GETPIVOTDATA() function to access pivot table data.

Regardless of trying to reference pivot table headers local to the workbook or as absolute values, I wasn't able to make it cooperate.

As another misfortune, you can't create a table which explicitly references another. So while you can create a new column with cells referencing cells, any expansion or contraction of the table may cause those outside cells to become inaccurate.

I know it's been a while since this question but I've just crossed with the same problem and the answer is: you just copy the formula used in the previous calculated field in the new one and add the remaining calculations to it.

Imagine you have this as the first calculated field: Calculated field 1 = SUM(Column name A) / SUM(Column name B) * COUNTA(Column name C)

And on the second calculated field you want to achieve this: Calculated field 2 = Calculated field 1 * COUNTA (Column name D)

Since you can't do it, it becomes like this: Calculated field 2 = SUM(Column name A) / SUM(Column name B) * COUNTA(Column name C) * COUNTA (Column name D)