cancel
Showing results for 
Search instead for 
Did you mean: 

YTD calculation at product level

Former Member
0 Kudos


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.

ProductMonthNo entriesYTD
ABCAUG100700
SEP100
OCT100
NOV100
DEC100
JAN100
FEB100
MAR100
APR100
MAY100
JUN100
JUL100
BCDAUG1080
SEP10
OCT10
NOV10
DEC10
JAN10
FEB10
MAR10
APR10
MAY10
JUN0
JUL0

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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