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)
 SSRS Matrix Compare Cell

Author  Topic 

cipriani1984
Constraint Violating Yak Guru

304 Posts

Posted - 2012-11-30 : 10:28:42
Hi,

I have the following Matrix:

Time
Country Count

If I wanted to add a row below that compares the valies between counts, so obviously the 'Time' will expand but the Count below going across has a cell below to should the difference between 'Current' cell and 'Previous' Cell.

I tried the Previous() function, but do I need to reference the cell name?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-12-02 : 03:23:47
sorry your explanation is not clear. can you post a screenshot of how you want column to appear?

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

Go to Top of Page
   

- Advertisement -