Skip to Content
0
A J
Sep 24, 2008 at 07:49 AM

Query display Net amount by soldto and aggregate some soldto together

26 Views

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.