Database Reference
In-Depth Information
5. The value of
Value expression
should be set to
[Measures].[Sales
Amount]
.
6. Specify the following value in
Goal expression
:
case
when isempty(
parallelperiod(
[Order Date].[Hierarchy].[Calendar Year],
1,
[Order Date].[Hierarchy].currentmember
)
)
then [Measures].[Sales Amount]
else 1.18 *
(
[Measures].[Sales
Amount],
parallelperiod(
[Order Date].[Hierarchy].[Calendar Year],
1,
[Order Date].[Hierarchy].currentmember
)
)
end
The preceding expression first checks if the previous year is empty, meaning
that this is the first year where we have recorded sales or there were no
sales the previous year. If that is true, it sets the value to the current Sales
Amount. If there are sales recorded for the previous year, it sets the goal to
an 18-percent increase.
7. Next, the value of
Status indicator
should be set to
Shapes
.
8. Then type the following formula as the value of
Status expression
:
Search WWH ::
Custom Search