October 21, 2016 at 3:12 pm
I'm going to cross post this to the SSRS area as well as I'm not sure where it best fits.
Imagine having the following columns:
Begin of Sales Date
Ramp Up Months
Annual Sales Projection
Annual Percentage Increase
Revenue Duration
Ramp Down Months
So basically an item can have a begin of sales date of 1/1/2016, with a 4 month ramp up. After that we hot the Annual sales projection which increases annually by the Annual Percent Increase percentage until we hit the Revenue duration at which point it will ramp down for the number of Ramp Down Months. The good thing is that the ramp up and down are evenly spread, ditto for the Annual % Increase. So if I have a $100,000 Annual Sales with a 10 month ramp up, I'd have $10k, $20k, $30k, etc. until I reach the $100k.
The challenge is that I need to build an SSRS report containing a matrix to show the projected revenue per month, in a matrix of course, based on a given start and end date. I'm having a challenge making it work in SSRS and am wondering if it would be easier to build a view and populate it with the sales amount by month and year, placing all the math in the view and making the report a piece of cake. I've made the matrix work and can place the (fixed) annual revenue in the cells from the begin of sales date through the end, I'm just stuck making the values increase per month / cell.
Any input is greatly appreciated!
Dexter
October 25, 2016 at 11:11 am
This fits best in SSRS since you say it's an SSRS post.
Everyone please respond to this link instead of here: http://www.sqlservercentral.com/Forums/Topic1828200-150-1.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply