Hello.. I would like to know how this can be done in RS (SQL2000)...
In the dataset I have... sales, company, and year. What I want to display is such...
2005 2006 Growth
companyA $1,000,000 $500,000 100%
companyB $50,000 $100,000 -50%
How do I add a column in a Matrix to calculate the growth based on the sales? Thanks!
-Joseph
you would have to add growth to your dataset as a calculation in of the years. So for MDX you would add a calculated member to the time dimension and calculate growth in that.
No comments:
Post a Comment