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.