Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

    1 Answer 1

    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

    Your Answer

     
    discard

    By posting your answer, you agree to the privacy policy and terms of service.

    Not the answer you're looking for? Browse other questions tagged or ask your own question.