Skip to Content

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

WEBI Crosstab - Insert a row with a custom subtotal

Hello all,

I am attempting to add a custom subtotal in the middle of a cross tab report which is being used as an income statement. The purpose is to show profitability as Gl accounts are included.

I am using the crosstsb with breaks for different GL groupings. The crosstab calculates the subtotal for each break correctly. However, I need to be able to do a calculation accross multiple breaks as demonstrated by the rows with **** in the example below. I am able to inert the row but the calulation seems to only include the values from the individual break.

Advice would be appreciated.

GL AccountsJanFeb
Sales acct 1100
Sales acct 2110
Subtotal Sales210
Direct Cost Acct 120
Direct Cost Acct 230
Subtotal Direct costs50
**Sales Minus Direct Costs**160
Indirect Costs Acct 115
Indirect Costs Acct 225
Subtotal Indirect Costs40
**Sales Minus Costs**120
Former Member
Not what you were looking for? View more on this topic or Ask a question