CODEWITHSUNDEEP
excelexcel-formula
user1902849
user1902849

Reputation: 1141

Can i use excel function in pivot table

In excel pivot table (data are derived from database), how can I do a calculation on selected field ? example below, value of column G is equal to 'sum all value from column A to E then total sum minus with value F'. How can I do this calculation in pivot table without touching database ?

A    B    C    D    E    F    G
100  200  300  400  500  989

Upvotes: 1

Views: 158

Answers (1)

M.Awais
M.Awais

Reputation: 26

Jerry is right you can add "calculated field" in your pivot using following formula only if all A-f are different fields/columns in database.

to add calculated filed follow following steps:

  1. click anywhere in your pivot

2.then select on calculated field button in Options ribbon under formulas. or press Alt+JTJF on keyboard.

  1. type new column name in "name" and enter following formula in "formula" and click ok

Formula:

= A+ B+ C+ D+ E- F

You can replace A,B,C,D,E,F with actual names/titles of columns.

Upvotes: 0

Related Questions