Skip to Content

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

Subtotals with EVSUB

Hi all,

I'm using SAP BPC 7.5 NW.

My input schedule has Cost Center, Account dimension on rows and year, category on columns.

I need to insert a sub total for each cost center member changing.

I've tried to use EVSUM and AfterRange function in the expansion range but it putted a grand total in the last row of the input schedule instead of many subtotals for each cost center. I've also tried to insert EVSUB and AtferRange in the SortRange but it doesn't work.

here is my SortRange

PARAMETERSortCol1SortCol2
ColumnPW
OrderAA
BeforeRange
AfterRangeTest!$O$2:$AC$2

Consider Column1 is Cost Center, Column2 is Account

How can I solve the problem?

Thanks in advance.

Andrea

Tags:
Former Member
Former Member replied

Hi,

Probably the answers has been discussed several times. Just you need to find threads like this -

Excel BPC - Totals & Subtotals

EV_AFTER : Adding grand total BPC 7.5

Regards,

Bishwajit

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