Skip to Content

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

Dual Structure and Subtotals

Hello,

I've created a query in BEx that has a dual structure that serves as our company's income statement. So for example, for each of our "account groups" I've defined the cells accordingly. However, within the structure I want some of the cells to list out the individual accounts and I want some of the cells to only be a subtotal of the individual accounts. For example:

Salaries_001

-GL acct 001_01 $100

-GL acct 001_02 $100

-GL acct 001_03 $100

Employee Benefits_002

-GL acct 002_01 $100

-GL acct 002_02 $100

-GL acct 002_03 $100

Total Salaries and Employee Benefits $600

I can't seem to get the "Total Salaries and Employee Benefits" for the two account groupings to just sum the accounts - it lists out each of the six accounts. I hope this makes sense. Thank you in advance for any help.

-Jeanie

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