Pivot table report

[lorrdon]

I'm new to using this feature , using Excel X, and have a problem.
I have a spread sheet with the following columns, DATE, CODE ( a
numeric code to identify type of expense or income ), CHECK #, CHECK
AMOUNT, DEPOSIT AMOUNT.
I can get a pivot report that tells me everything I want to know except
a dollar total by code number.
Can I get this ? How ?

 

[infectiologue]

You need to put the code on the left (group) side, and CHECK AMOUNT in
the data area. If you do that first, you will get the sum
auto-magically. However, if it says Count of CHECK AMOUNT instead,
control click to get Field Settings and choose Sum instead of count.
You have to scroll up one in the list, so it is easy to miss.

I hope this helps,

 

[HansE]

Hi,
you have to use SOM in that field


lorrdon schreef: