Display the Last 12 months data in the bar chart

[#1]

Hi,

I wish to display last 12 months in the dimension axis and the corresponding sales value for each month.

I have created two variables:

vMaxMonth- to store the latest month

vLast12Month- to store the previous 12th month.

How do i use this in the chart?

Thanks,

Asma

[ecolomer]

See this example

[#3]

Hi Asma

The options you need to edit will be in the chart properties dialogue, under the "dimension limits" tab.

Here, you will need to select the "restrict" option under the limits section (right hand side) and use the option "show values that are:"

In this section you can set values that are "greater than" your "exact amount" Which will be your variable.

Does this help?

Erica