Post reply

Matrix - Suppress overall Grand Total

  • July 10, 2008 at 9:31 am

    #190352

    Does anyone know a way of suppressing the overall grand total in a Matrix ?

    For my report I have vertical totals and horizontal totals which make business sense, but the overall Grand Total figure would be adding apples and oranges.

    It's the total on the bottom right hand side of the matrix that I'm on about here.

  • July 10, 2008 at 5:53 pm

    #841179

    G'day mate,

    I'm not sure where your grand total is. Maybe this is some flash feature that I haven't seen in SRS2k5? I am using 2k..

    I have just loaded one of my simple matrix reports and cant see any "Grand Total".. As you mentioned you have horizontal and vertical totals which can be enabled/disabled by just right-click "subtotal" as you probably aware, but it sounds like you're talking about something additional to these.

    I know a screenshot would definately help me in this.

    - Damien 😀

  • July 11, 2008 at 1:57 am

    #841294

    Thanks for the reply there.

    The offending item is circled in red in the GIF attached.

  • July 13, 2008 at 11:00 pm

    #842186

    Hi Mate,

    I've replicated your issue, but unfortunately not been able to produce an easy answer.. I wouldn't be surprised if this is the wrong way to do it, but could you create another dataset with the totals for each line sum/grouped as you want and then use a Table alongside your Matrix for a run of totals?

    You'd have to make sure that the Matrix dataset and your Table dataset were hard coded to sort data the same way every time, but it might solve your issue.

    I'd be surprised if there wasn't a better solution though 😛 No guarantees on this solution either. It has hatched in my brain, but I haven't tried it.

    Good luck! I'll leave this one for a pro! - Damien

  • July 15, 2008 at 2:54 am

    #842889

    Hi,

    Try the following expression for the visibilty property of your "values" textbox:

    =(NOT Inscope("NameOfRowGroup") AND NOT Inscope("NameOfColumnGroup"))

    Change NameOfRowGroup and NameOfColumnGroup to the group names of your matrix.

  • July 15, 2008 at 3:07 am

    #842891

    Thanks again for the reply Damien.

    xanthos - you're a genius !! Thanks so much.

    Fair play and thanks.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply