Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My SUBTOTAL row shows Person A needs £115, Person D £234 and Person G £789, but how do I SUM those totals and get it to show the total on the same ROW?

  • The Rows are subscription names.
  • The Value field holds the Cost per subscription.
  • the Columns holds the name of the person who receives the subscription.
  • I have GROUPED on YEAR & MONTH, and have a subtotal that shows me how much each person will need to pay each month for all their subscriptions, but I need a figure showing me the total of all the subscriptions per month.

    I've tried adding calculated fields, but I want to SUM the subtotals so I'm struggling to see the field I need to use. I've tried Grand Totals but that SUMS all rows and I really only want SUM the Subtotal Total Row.

    I need a nice neat report that my managers won't go white at when looking at it...to many numbers = fear and confusion.

    Anyway it got messy, so I've come for help.

    UPDATE: I've found a way. It's not perfect but it'll do: use GRAND TOTALS for ROWS, and then format the totals you do not want to see in white

    Like I said, it's not perfect but it'll do. How do I close this post?

    Cheers

    Mike.

    share|improve this question
        
    You should be able to accept your own answer in two days, no need to close the post. – dsolimano Apr 7 '10 at 14:54
    up vote 0 down vote accepted

    I've found a way. It's not perfect but it'll do: use GRAND TOTALS for ROWS, and then format the totals you do not want to see in white

    Like I said, it's not perfect but it'll do. How do I close this post?

    share|improve this answer
        
    You don't need to close this post. If this answer is OK for you, just accept it as your own answer. – Mehper C. Palavuzlar Apr 7 '10 at 15:16

    You must log in to answer this question.

    Not the answer you're looking for? Browse other questions tagged .