Skip to Content

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

Query display Net amount by soldto and aggregate some soldto together

I have master data soldto, existed in InfoCube: Sales.

And Current Query display Net amount by soldto

Requirement: Query display Net amount by soldto and aggregate some soldto together.

Example:

-Current Query

soldto NetAmount

A 100

B 200

C 300

D 400

-New Query: A+B -> B

soldto NetAmount

B 300

C 300

D 400

Do Query Designer can?

Or build new model in BW?

Please help me.

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