Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

running total issue

I have a question regarding running total as below.

I want to display a table like this.

YYYY-MM Monthly MonthlyAccum Target TargetAccum

2011-04 100 100 200 200

2011-05 200 300 200 400

2011-06 500 800 200 600

2011-07 500 1300 200 800

2011-08 0 1300 200 1000

2011-09 0 1300 200 1200

2011-10 0 1300 200 1400

2011-11 0 1300 200 1600

2011-12 0 1300 200 1800

2012-01 100 1400 200 2000

2012-02 0 1400 200 2200

2012-03 0 1400 500 2700

First, I used "running total" for displaying accumulated data.

But it comes one month shift below.

YYYY-MM Monthly MonthlyAccum Target TargetAccum

2011-04 100 0

2011-05 200 100

2011-06 500 300

2011-07 500 800

2011-08 0 1300

2011-09 0 1300

2011-10 0 1300

2011-11 0 1300

2011-12 0 1300

2012-01 100 1300

2012-02 0 1400

2012-03 0 1400

Former Member
Former Member replied

Looks like you have placed the Running Total in group header.

RTs can only be used in Footers.

Ian

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question