Skip to Content

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

Sub Totals for selected columns

Hi,

I have a requirement wherein I have to insert subtotals for a certain set of rows and have individual rows that don't need sum in the same cross-table.

                             

COL2
INDI/GRPGRP#COL1
INDIXX1
GRPGRP11Y2
GRPGRP11Z3
TOTAL FOR GRP 1TOTAL5
INDIAA1
INDIBB5
GRPGRP22C4
GRPGRP22D4
TOTAL FOR GRP 2TOTAL8

I have managed to break on groups by creating a GRP variable. The condition for variable is that if the value belongs to a particular group it will get the value as <GRP#> here GRP1,GRP2, for other individual rows the value will be the same original value here X,A,B. But when I try to insert total, if I click on the measure and click on SUM function it inserts a row for every GRP(as needed) but also for every individual row(not needed). How do I delete that sum row for individual rows and keep them for the group rows?

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question