Matrix Report - Add Pct of Total Column -- sql server reporting services

sql server reporting services : Matrix Report - Add Pct of Total Column

OTSolutions NO[at]SPAM shaw.ca
8/4/2005 11:41:04 AM

How could I add a percentage of total column to a matrix that looks
like this:

Employment Status Owned Rented Total
Full-Time 10 10 20
Part Time 20 20 40
Totals 30 30 60

I want it to look like:

Employment Status Owned Rented Total Pct of Tot
Full-Time 10 10 20 33.3
Part Time 20 20 40 66.7
Totals 30 30 60 100.0

Any help would be appreciated.

Regards,

Tom Olthoff

James
8/4/2005 11:53:48 PM

Write your expression, format the textox using P or P2
[quoted text, click to view]

OTSolutions NO[at]SPAM shaw.ca
8/5/2005 7:36:09 AM

Ok, once I have the expression how do I add the column to the end of
the matrix? There is no Add Column when I right click the last column
on the matrix. Just Add Column Group, which does not do what I need it
to do.

Regards,

Tom

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn