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 |
|
MikeSQL
Starting Member
7 Posts |
 Posted - 2011-06-23 : 07:52:09
|
HiI have a product matrix that needs a percentage calculation based on each product sub-total. At the moment I can only get a % based on the matrix total not each column. So Product 1 for Supplier A currently shows 11% when it should be 17%.Any help would be appreciated. Matrix and Expression currently looks like this: Product 1 % Product 2 % Product 3 % TotalSupplier A 2 17% 2 50% 1 50% 5Supplier B 4 33% 1 25% 1 50% 6Supplier C 6 50% 1 25% 0 0% 7Total 12 4 2 18 =Count(Fields!Product.value)/Count(Fields!Product.value,"Product_Matrix")Thanks! |
|
|
LarryC74
Yak Posting Veteran
94 Posts |
Posted - 2011-07-27 : 15:09:48
|
| Have you got this figured out?What's the name of the "total" text box?Maybe try something like: =Count(Fields!Product.value)/ReportItems!Totaltxtboxname.valueEveryday life brings me back to reality |
 |
|
|
MikeSQL
Starting Member
7 Posts |
Posted - 2011-07-28 : 03:53:56
|
| Forgotten that I posted this!Yes I did resolve the problem, exactly as you have detailed.Many thanks for the reply though. |
|
|
|
|
|
|
SSRS Percentage on fields issues