Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Calgary, Alberta, Canada
    Posts
    818
    Thanks
    6
    Thanked 1 Time in 1 Post

    Pivot Tables - totals(sum) vs count?? (Excel 2K)

    I have a spreadsheet that I use to track expenses. Each expense has a Month and date and category and an amount. I am trying to use a pivot table to give me total expenses by category by month and monthly total expenses. When I try and build this one, I do not seem to be able to get the amount totals, but only total counts of each category in each month. <img src=/S/brickwall.gif border=0 alt=brickwall width=30 height=15> What do I need to do to get the total expenses by category, rather than the count by category? Any insight anyone can provide is greatly appreciated. Thanks. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Ron M

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Pivot Tables - totals(sum) vs count?? (Excel 2K)

    Ron,

    You should be bale to double click on the field name taht you want to change in th e Pivot Table, and then you should be able to select the method to summarize by, Count, Sum, Average etc.

    If you still have difficulties, try to upload a sample of you Pivit table (dummy data will suffice) so that we can advise on the exact struct in your case.

    Andrew C

  3. #3
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Calgary, Alberta, Canada
    Posts
    818
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Pivot Tables - totals(sum) vs count?? (Excel 2K)

    Thanks Andrew, that did the trick. <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Ron M

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •