Hi Everyone,

In a cube, I have a measure - Total Revenue.
One of the dimensions in the cube is Period - i.e. the period for
which the revenue is.
Another dimension is, say companies.

Is there a way to know whether the measure (Total Revenue) is growing
or declining in a particular period? Can I ask the cube to give me
values of the measure for all companies, where the measure is growing
in a particular period (month)?

If it is possible, what would the query be for this?

Or is it better to create some calculated member for this (to track
growing or declining measures)? If yes, how?

Thanks and regards

Vani