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 2005 Forums
 Analysis Server and Reporting Services (2005)
 Compare Row values

Author  Topic 

zolf
Starting Member

15 Posts

Posted - 2007-10-22 : 00:57:19

hello there,

i have a matrix which displays data for different products.i have grouped them by year and month.now i want to compare each month to the previous month and show an indicator that this month the sales was down or up.for that i need to compare a month with the previous month.how can i do this in reporting service.please help.

cheers
zolf

tm
Posting Yak Master

160 Posts

Posted - 2007-10-22 : 14:54:34
Have you tried Previous function in your expressions? Look under Common functions >> Miscellaneous >> Previous.

I tried this with Table and it works but have not tried with matrix.
Go to Top of Page
   

- Advertisement -