Skip to Content
Former Member
Dec 05, 2011 at 09:27 AM

Dynamic section in a fixed Bex structure


Hi experts,

I have such a report requirement from the client, which is similar to a monthly income statement of an insurance agent:

+Opening Balance: xxx EUR

+Total Commission Type 1: xxx EUR

+Total Commission Type 2: xxx EUR


+Total Commission Type N: xxx EUR

+Miscellaneous Income: xxx EUR

- Payment:

-- Payment 1

-- Payment 2


-- Payment n

+New Balance: xxx EUR

I have modeled this report with a Bex structure in Query Designer. But I have a big problem dealing with the line "Payment", because it is not a fixed structure. One agent can receive up to n payments in a month and I have to list out every payment.

So I would like to ask if there is a workaround for designing such a requirement?

Thanks in advance!