on 12-22-2014 11:10 AM
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
PARAMETER | SortCol1 | SortCol2 |
Column | P | W |
Order | A | A |
BeforeRange | ||
AfterRange | Test!$O$2:$AC$2 |
Consider Column1 is Cost Center, Column2 is Account
How can I solve the problem?
Thanks in advance.
Andrea
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bishwajit,
thanks for your quick reply.
I've already checked these posts but in my case EVSUM it didn't work as expected.
It didn't put a subtotal row for each row value change, it putted only the grand total.
If this can help you here is my expansion range.
PARAMETER | EXPANSION 1 | EXPANSION 2 | EXPANSION 3 | EXPANSION 4 |
ExpandIn | ROW | ROW | ROW | ROW |
Dimension | ENTITY | ENTITY_CDC | ACC5LEV | INTCO |
MemberSet | BAS | BAS | TO_PLN="P" | BAS |
BeforeRange | ||||
AfterRange | Test!$X$1:$AC$1 | |||
Suppress | Y | |||
Insert | BAS | BAS | TO_PLN="P" | BAS |
Thanks
Thanks Vadim,
it was my fault, good advice!
I'm gonna delete this post.
Thank you all.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.