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 |
|
muzzettemm
Posting Yak Master
212 Posts |
 Posted - 2009-03-05 : 13:06:08
|
| Hi guys I 2 matrix in a report and I need to be able to filter by date and still get the total overall amount. for instance if I need to show data for the month of March and also for the whole year how would I do that in the expression??=Sum(Fields!NewHireApplicants.Value) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-05 : 13:15:07
|
| you need to make sure data for whole year is available in matrix, so filetr only for year. then to get month data apply grouping on month. and if you need any particular months data alone use IIF expression likeSUM(IIF(Fields!month.value="March",...,...) |
 |
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2009-03-05 : 13:21:58
|
| I'm sorry what I meant was as the year goes on, so if I'm wanting to show the data for March that plus the total sum up too March as in January - March. does that make sense??? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-05 : 13:27:17
|
| you mean running sum also? you can use runingvalue function for thathttp://msdn.microsoft.com/en-us/library/ms159136.aspx |
|
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2009-03-05 : 14:15:34
|
| nevermind thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-08 : 13:13:17
|
| welcome |
|
|
|
|
|
|
Filtering