Ordering a Total column in a matrix control

  • Hello

    I've been trying to order a sub-total column in a matrix control. Is it possible and if so any ideas?

    Many Thanks

    robhob

  • I'm trying to figure out how to add a total column to a matrix table?  When I add a column, it adds it for each occurrence of my series rows...any thoughts?

  • Found out how to add a sub-total, but how do I make that an average instead of a total?

  • Right Click on the Column header and select sub-total, there is no option for avg at this time according to Microsoft Reporting Services in Action.  (Book has been a real help)  You can do either a row or column sub total this way.

    Kurt Kracaw

  • Actually, the sub total will produce whatever the aggregate function is in the detail cell, so if it is an average, it will produce an average subtotal rather than a sum.

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

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