on 07-21-2014 8:06 AM
Hi Friends,
Am not sure if this is the right forum to post a BW question.
I have a requirement to calculate YTD, however the way this has to be calculated is a different.
We have multiple products, but for each product we have different periods(start and end period), Start period is August for all products, however the end period for each product varies.
Product Start period End period
ABC AUG APR
BCD AUG MAR
CDE AUG FEB
The requirement is that when the user runs a report, in the selection screen if he/she selects for example a period(month) as 02.
Then the report should show YTD calculation from AUGUST to FEB as a total.
Also if there are any additional values beyond the end period they should be displayed in their respective month columns.
Please see the example below how the report out put should be.
Product | Month | No entries | YTD |
ABC | AUG | 100 | 700 |
SEP | 100 | ||
OCT | 100 | ||
NOV | 100 | ||
DEC | 100 | ||
JAN | 100 | ||
FEB | 100 | ||
MAR | 100 | ||
APR | 100 | ||
MAY | 100 | ||
JUN | 100 | ||
JUL | 100 | ||
BCD | AUG | 10 | 80 |
SEP | 10 | ||
OCT | 10 | ||
NOV | 10 | ||
DEC | 10 | ||
JAN | 10 | ||
FEB | 10 | ||
MAR | 10 | ||
APR | 10 | ||
MAY | 10 | ||
JUN | 0 | ||
JUL | 0 |
Can someone please let me know how to do the above?.
I have gone thru the forum and read threads reagrding YTD, looks like this requirement is different then the standard YTD calculations. Hence posting this.
Regards
BN
Hi Kumar,
Please tell me are the start and end periods are coming as transaction values(i.e in Target) and all the months data is available or not like continuity in the months,there should be any record with jan'14 data,no feb'14 data Mar'14 data like that.
Regards,
Rambabu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.