Skip to Content
0

BW - multipilication within a query

Dec 13, 2016 at 12:19 PM

43

avatar image

Hello,

I have the following issue within a BW-query:

Data

1 2 3 4 5
Sales Office Item sales quantity profit per kg total profit

4711 100 50 100 5.000

4711 100 60 30 1.800

4712 110 50 25 1.250

Within the cube I have the data according to columns 1-4 (not 5).

Within the query I want to present

1 2 3 4
Sales Office Item total profit

4711 100 6.800

4712 110 1.800

How can I accomplish that?
I know that simply adding the profit per kg does not make sense.

Is there - perhaps - any function within Analysis Office which could here on the level of

the worksheet?

Thanks a lot for any tip

Thomas

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers