Display 2 different measures using a time dimension

[voetpad]

when using a time dimension (like QTD change) I see only one measure. Example : the change of quantity. But I want to see 2 measures using one time dimension.

Example: I want to see the QTD change of quantity and QTD change of costs at the same time.

How can I do that?

 

[christenhusz]

Hi voetpad,

You can use all measures in the report (add as row or column with for example drag and drop) or nest one or more additional measures in the report.

Groeten,

Christenhusz

 

[voetpad]

It works.

In powerplay I used it to calculate the price elasticity. But is it possible to include this calculation inside a cube?

This is the calculation:
(new quantity - old quantity)/old quantity
/
(new price - old price)/old price.

The price and the quantity are know in the cube. But they are time related.
Example : March price = 20 quantity = 10000
April price = 19 quantity = 11000