Share via

Add columns in Pivot Table

Anonymous
2023-04-18T17:51:09+00:00

Is it possible to add a column with a calculation based on the values ​​of Column1 Column2 and Column3?

for example, in this screenshot. This is my pivot table and I need to add a column based on the Values Field "Precios". Like =Column1/Column2-1

Is it possible?

Thank you

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-04-18T18:04:51+00:00

    You can add calculate field from PivotTable Analyze

    Result

    0 comments
  2. Anonymous
    2023-04-18T19:12:36+00:00

    I tried this but if you take a look at "Values" box in the pivot table I've only one field call "Precios" and when I attempt to do this it leads me to an error cause I can't do a calculated field with "Precios/Precios-1"

    Hope you can understand me

    Thank you for your help

    0 comments
  3. Ashish Mathur 100.9K Reputation points Volunteer Moderator
    2023-04-18T23:44:00+00:00

    Hi,

    This may be possible to solve with the Query Editor and PowerPivot. Does your version of MS Excel support the PowerPivot? If yes, then share the download link of the MS Excel file. Since the PowerPivot is crashing on my system, i will share my solution in PowerBI Desktop. You can understand my transformations and DAX formulas there and replicate the same in your MS Excel file.

    In the file that you share, please share English column names.

    0 comments