| Author |
 Topic  |
|
|
nord
Yak Posting Veteran
66 Posts |
 Posted - 02/06/2013 : 10:44:08
|
Hi,
i have matrix like
1 2 3 4
2 3 2 4
1 2 3 4
sum 12 20 27 15
how can devide sum/row=%
Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47023 Posts |
Posted - 02/06/2013 : 11:08:11
|
is sum part of same resultset or is it summary row in ssrs report?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
|
nord
Yak Posting Veteran
66 Posts |
Posted - 02/06/2013 : 11:11:43
|
| is it summary row in ssrs report |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47023 Posts |
Posted - 02/06/2013 : 11:19:24
|
SUM(Fields!Yourfieldname.value,"Table Name")/Fields!YourField.value
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
nord
Yak Posting Veteran
66 Posts |
Posted - 02/06/2013 : 11:24:49
|
| Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47023 Posts |
Posted - 02/06/2013 : 11:29:19
|
welcome
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
nord
Yak Posting Veteran
66 Posts |
Posted - 02/11/2013 : 10:34:57
|
Hi,
How I can in same example make runningvalue?
thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47023 Posts |
Posted - 02/11/2013 : 10:37:52
|
=RunningValue(Fields!Yourfieldvalue.Value, Sum, "table name")/RunningValue(Fields!Yourfieldvalue.Value, Sum,Nothing)
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
nord
Yak Posting Veteran
66 Posts |
Posted - 02/11/2013 : 10:49:23
|
I wrote like that:
=RunningValue(Fields!credit_complet_qty,Sum,Nothing)/RunningValue(Fields!credit_complet_qty.Value,Sum,"cal1")
but in every colimn result is:error.... |
|
|
|
James K
Flowing Fount of Yak Knowledge
1483 Posts |
Posted - 02/11/2013 : 12:09:45
|
Either one or the other as shown below?:=Fields!credit_complet_qty.Value/RunningValue(Fields!credit_complet_qty.Value,Sum,"cal1")
=RunningValue(Fields!credit_complet_qty.Value,Sum,"cal1")/SUM(Fields!credit_complet_qty.Value,"cal1") |
|
|
|
nord
Yak Posting Veteran
66 Posts |
Posted - 02/11/2013 : 13:36:51
|
| thanks,second one perfect!!! |
|
|
|
James K
Flowing Fount of Yak Knowledge
1483 Posts |
Posted - 02/11/2013 : 19:01:18
|
| You are very welcome - glad to help. |
|
|
| |
Topic |
|
devide sum to row
