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 |
|
ggarza75
Yak Posting Veteran
50 Posts |
 Posted - 2014-12-02 : 11:37:49
|
I'm creating a report that displays data in a Matrix tablix by month and business unit.I pretty much have it completed minus one crucial part that I need.As you can see in the picture, I have data for 07/2014 and 08/2014. Ending count for 07/2014 is -247. I'm wanting that -247 value to be displayed where the 0 is located right under 08/2014. Once I get the number in place, I'm going to subtract that value with the new month's total, giving me an Ending Count.I thought I could use the PREVIOUS function, but it only worked for the previous row value, not column value.Thanks for any assistance. |
|
|
|
|
|
Getting Previous Month Total in Matrix Tablix