Aggregating Total - Help. - 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)

Aggregating Total - Help.

Author

Topic

Kapital123
Starting Member

31 Posts

Posted - 2012-06-24 : 08:16:27

Hello,

I am a new user of SSRS 2008 and SQL in general. Currently I am in the process of creating a report, however I have a problem in achieving what I would like. These are the 4 columns in my current report:

AU De OP $12
AU De FX $13
EU De FX $6
GBP Bo Cor $8
EU De FX $14
AU De FX $9
GBP De FX $2
.. .. .. ..

What I would like to have is be able to aggregate column 3 and 4 by column 2 and 1. Sorry I do not how to explain it exactly but something like this

AU De OP $12
AU De FX $22 ($13+ $$9)
EU De FX $20 ($6 + $14)
GBP Bo Cor $8
GBP De FX $2
.. .. .. ..

I will greatly appreciate any insights anyone can give.

Thankyou

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-24 : 10:14:20

add a group in report on first three fields and add expression = SUM(Fields!field4name.value) inside data portion of group in report. First 3 fields just drag and drop it inside group

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

Kapital123
Starting Member

31 Posts

Posted - 2012-06-25 : 07:54:16

Thank you I will try it.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources