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 |
|
ctdavidcccoe
Starting Member
1 Post |
 Posted - 2011-12-08 : 02:29:54
|
| I'm fairly new to BIDS and SSRS. I'm writing a query to that needs to subtotal transaction type for the rows and period on the columns. I have 3 transaction types, Reciepts, Disbursements and Prior Year transactions. I can subtotal for each of these. However, I need a field in each period column that will take (Reciepts - Disbursments + Prior Year Transactions).Row is Grouped by Fund > Transaction Type > Transaction CodeColumn is Grouped by Period.I'm hoping for some friendly help. I'm stumped on this one.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-08 : 07:00:01
|
| add a column inside column group containing period and put the following expression=Fields!Reciepts.value - Fields!Disbursments.value + Fields!Prior_Year.value------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Calculations in SQL Matrix Report in BIDS