all groups > sql server reporting services > july 2005 >
You're in the

sql server reporting services

group:

Difference instaed of total within matrix


Difference instaed of total within matrix Tango
7/26/2005 11:37:02 PM
sql server reporting services:
Hi There,
I have a matrix that has a column group by pay period then another column
group by definition (actual & budget), a data field called hours which look
like this

paydate1 paydate2
totals
Actual Budget Difference Actual Budget Differnce
Actual Budget
location a 10 6 4 8 6
2 18 12 6

Problem is i need assistance on how to add the difference column for each
pay date and a totals column for actual budget & difference for all pay dates.

thankyou
todd
RE: Difference instaed of total within matrix Antoon
7/27/2005 8:58:10 AM
I think the easiest thing to do is do the calculations in the query, that is
very easy if your calculations are just another column.

[quoted text, click to view]
RE: Difference instaed of total within matrix Tango
7/27/2005 3:26:02 PM
Thats the thought that come to me after posting. Thank you so much for just
replying. I have been quite frustrated by the lack of response to this
question which i thought would have been a common one. I have posted this a
number of times & heard nothing.

Ill now try to work out how to do this in a query.

Have a great day.

Todd

[quoted text, click to view]
AddThis Social Bookmark Button