Operations with datas

I'd like to make a substractions between result of year 1 and result of year
2.
I've made a matrix with year in colums?
Can I make his operation easily or have you got an other solution?
Please, help me.
Thanks in advance
NicolasI was able to do a similar calculation. I have a column group by month, and
then columns within the month showing Open and Close values. I was able to
subtract the Open and Close values by inserting a column in that row. Right
click on the column and you should see Add Column (not Column group). There
may be another way that I'm not aware of.
"Nicolas BRESSAN" wrote:
> I'd like to make a substractions between result of year 1 and result of year
> 2.
> I've made a matrix with year in colums?
> Can I make his operation easily or have you got an other solution?
> Please, help me.
> Thanks in advance
> Nicolas|||You could do this in the query ( if you'd like to post it...)
Or you might try the Previous function
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nicolas BRESSAN" <NicolasBRESSAN@.discussions.microsoft.com> wrote in
message news:091A070B-78A2-46A9-8753-D518D353DDF9@.microsoft.com...
> I'd like to make a substractions between result of year 1 and result of
> year
> 2.
> I've made a matrix with year in colums?
> Can I make his operation easily or have you got an other solution?
> Please, help me.
> Thanks in advance
> Nicolas