Sum of field in pivot table

M

mabubakerali

New Member
Joined
Feb 23, 2016
Messages
35
I am trying to make a ledger from general journal using pivot table, but in the sum of field2 column when i use sum of field, it returns the value debit-credit for example as you can see see in the screenshot the value in F5 cell is D5-E5 but i want it to be like, F4+D5-E5. Please help.
 

Attachments

  • Excel ledger screenshot.png
    Excel ledger screenshot.png
    95.6 KB · Views: 10

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
You must log in or register to reply here.

Similar threads

E
  • Question Question
Trial Balance, INDEX/MATCH, Multiple Criteria, and SPILL
Replies
2
Views
483
Cubist
Cubist
datatronics505
  • Solved
Absolute reference to a cell of another table
Replies
5
Views
228
datatronics505
datatronics505
M
  • Question Question
Help with the journal to ledger automation.
Replies
3
Views
343
SanjayGMusafir
SanjayGMusafir
G
  • Question Question
Edit pivot table cells
Replies
4
Views
390
Cubist
Cubist
N
  • Question Question
Column with Min/Average values at the end of Pivot Table
Replies
0
Views
170
Nurces
N

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top