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

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Pivot Tables – totals(sum) vs count?? (Excel 2K)

    Author
    Topic
    #362061

    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. brickwall 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. smile

    Ron M

    Viewing 0 reply threads
    Author
    Replies
    • #549025

      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

      • #549042

        Thanks Andrew, that did the trick. smile smile smile

        Ron M

    Viewing 0 reply threads
    Reply To: Pivot Tables – totals(sum) vs count?? (Excel 2K)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: