Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Apr 2008
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subtotal (professional 2003)

    I have a report that has needs be subtotaled based on filter sort. Please help. Example attached. I need a subtotal for each SOS CD. Like ECA and NBC.

    So that in a report it would show each subtotal in dollars. It could also be on a seperate page.

    Thanks,
    Jimmy
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subtotal (professional 2003)

    If you sort the table on SOS CD, you can use Data | Subtotals to add subtotals. You can select the field to break on (SOS CD) and one or more fields to calculate subtotals for (presumably total_exp).
    Or you can create a pivot table based on the data table: Data | Pivot Table and Pivot Chart Report.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Subtotal (professional 2003)

    I am not completely sure what you want the output to be.

    You can use the subtotal routine (under DATA) to add subtotals to sorted list

    You can use the SUBTOTAL function to get live stats about fitlered data

    You can create a pivot table to put a summary list on another sheet (or the current sheet)

    Could you elaborate?

    Steve

  4. #4
    New Lounger
    Join Date
    Apr 2008
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subtotal (professional 2003)

    sdckapr

    Well, I know MS Access could do it. I usesd the count total once before. But forgot. how.

    Jim
    Attached Files Attached Files

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Subtotal (professional 2003)

    You can do this with a pivot table
    Select a cell in the data in Sheet1
    Data - Pivot table and Chart report...
    <Next><Next>
    <Layout>
    Drag <Sos_Cd> to the "row"
    Drag <total-exp> to the "data" (should say "Sum of total_exp"
    <OK><Finish>

    You can change options and other layout if desired...

    Steve

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subtotal (professional 2003)

    The attached workbook contains a worksheet showing subtotals, and a worksheet showing a pivot table.
    If you click in the pivot table, and select Pivot Table | Show Pages from the Pivot Table toolbar, Excel will create a separate sheet for each value of SOS_CD.
    Attached Files Attached Files

  7. #7
    New Lounger
    Join Date
    Apr 2008
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subtotal (professional 2003)

    Yes,

    It worked. One more question. I am having trouble adding another tabe to either an exixting sheet or the same one.

    Any clues ?
    Jim

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subtotal (professional 2003)

    Do you mean a table with subtotals or a pivot table? And what exactly is the problem?

  9. #9
    New Lounger
    Join Date
    Apr 2008
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subtotal (professional 2003)

    Thank you, I got it
    Jim

Posting Permissions

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