I have my bank account statement and what I would like to do is group the descriptions of the transactions together with their debit or credit and sum their total. I could then see that, e.g., for ebay.com my total debit was $2000, etc.

Description   Debit Credit
A              1
B                     1
A                     1
B              1
C              1
D                     1
A              1

What I want to do is use a pivot table

Description   Debit Credit
A                3
B                      2
C                1
D                      1

I am no able to do that, as I can't group the description and have additional debit and credit columns -- I get them all in rows with blanks.


In this scenario you are probably better off to use a regular table instead of a pivot table and turn on the totals row and display the SUM for your credits and debits and then use a filter on your description column (eg. ebay.com) to limit the rows displayed and summed in the total row at the bottom.


@Mike is always correct but since you asked for a pivot table:


Note that this is based on your data input example, so does not match your data output example.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.