Skip to Content
Former Member
Aug 18, 2011 at 07:39 AM

How to control different acct number in Bex Query Designer


I have created 1 income statement using query designer which in the column has key figures such as company code, Amt and Fiscal year/period. Each column represent different company code. Example column 1 represent company A, column 2 represent company B and column 3 represent company C.

In row, i have sorted the account number and categorised it as below item:

- Admin Expenses

Acct no 10000

- Other Operating Expenses

Acct no 10000


For company A, and C, the acct no 10000 should appear in Admin Expenses.

For company B, the acct no 10000 should appear in Other Operating Expenses.

How do i control these account number to be appear in different item for different company?

Thank You and Best Regards.