Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Group by PT issue (Excel 2003)

    I have columns for YR1...YR27 in a PT, plus an INIT LIAB field and a COUNT of locations field. I have the Table Options set to summarize Rows and Columns but the Rows do not sum across even when I delete the COUNT field. Why won't the PT give me totals, as I usually get? Does the answer explain why I cannot group the INIT LIAB....YR27 columns into a TOTAL LIAB Group?

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

    Re: Group by PT issue (Excel 2003)

    Can you post (a stripped down copy of) the workbook?

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Group by PT issue (Excel 2003)

    This PT has the Row and Column Total option set, but even before I added teh Count of Units, it wouldn't give me row totals. Also, it gives you the "Can't group" arguement. TYIA
    Attached Files Attached Files

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

    Re: Group by PT issue (Excel 2003)

    You can't group because YR1, YR2 etc. are not 12 different values of one variable, but 12 different variables. That is also the cause of the absence of row totals.
    If you want to group YR1 to YR12, you must do so by adding a column with formulas in the source range. Or change the setup of the source data so that YR1 etc. become the values in a single column (you'd have fewer columns but far more rows).

  5. #5
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Group by PT issue (Excel 2003)

    Ah HA! Thanks. Will work on it.

Posting Permissions

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