Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TJFeinstein
Starting Member
1 Post |
 Posted - 2012-05-18 : 11:12:20
|
| I have a Client group with a total and multiple subtotals. I would like to calculate the % of that subtotal to the Total of the client. There are multiple clients on the table so I can't divide by total of the dataset. Please help.Thank you.Terri |
|
|
rjscott94803
Starting Member
1 Post |
Posted - 2012-05-22 : 11:40:20
|
| For items like this, I create views of the data and then import to Excel. Makes repoting off of this easier (as I am usually asked to deliver results to the requestor - makes it easier for them to comprehend) and the data is then dynamic so refreshed data doesn't have to be reformatted.Thanks for taking the time to read. Richard |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-23 : 14:36:01
|
| if you want to do this in report you need to use aggregate functions with correct scope. so in your case the expression would be like=SUM(Fields!yourField.value,"subgroupname")/SUM(Fields!yourField.value,"clientgroup")and set format to standard percentage format in cell properties------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Percent of subtotal