Change the total (sum generated function) in a matrix

Hi,

Can somebody help me ? I really need to create a matrix with totals but I don't need a to use a sum

I need another function (AVG, Count). Can it be done ?

How can I change the Total function to put another aggregate function ?

Thanks

cyprix,

Yes, you can change the SUM function to any aggregate, the BIDS just automatic places SUM for you but you can alter it.

Ham

|||

Hi hammer

I'd love 2 know where to alter it.
Fine i click on the little green traingle,
I can still only set the properties.

No option for an expression.

G

|||

Please tell me how to make the change. If I click the green triangle I cannot edit the formula.

Thanks,

|||

cyprix,

I'm giving you a link to Robert B. MSFT solution for your problem.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=364020&SiteID=1

Ham

|||

Thanks H

Good to see an alternate workaround to the one i'm using

G