devide sum to row - SQL Server Forums

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.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

devide sum to row

Author

Topic

nord
Posting Yak Master

126 Posts

Posted - 2013-02-06 : 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

52326 Posts

Posted - 2013-02-06 : 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
Posting Yak Master

126 Posts

Posted - 2013-02-06 : 11:11:43

is it summary row in ssrs report

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-06 : 11:19:24

SUM(Fields!Yourfieldname.value,"Table Name")/Fields!YourField.value

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

nord
Posting Yak Master

126 Posts

Posted - 2013-02-06 : 11:24:49

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-06 : 11:29:19

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

nord
Posting Yak Master

126 Posts

Posted - 2013-02-11 : 10:34:57

Hi,
How I can in same example make runningvalue?
thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-11 : 10:37:52

=RunningValue(Fields!Yourfieldvalue.Value, Sum, "table name")/RunningValue(Fields!Yourfieldvalue.Value, Sum,Nothing)

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

nord
Posting Yak Master

126 Posts

Posted - 2013-02-11 : 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
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-11 : 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
Posting Yak Master

126 Posts

Posted - 2013-02-11 : 13:36:51

thanks,second one perfect!!!

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-11 : 19:01:18

You are very welcome - glad to help.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources