Dimension value set table selection

[#1]

Hi there,

I have a table of budgets based on months, please see below for example.

Financial Month	Budget
January	15,000
February	20,000
March	25,000
April	30,000

I also have a data dimension that contains financial month data.

Effectively, what I want, is to be able to set a variable based on the selection of a dimension value. So if the financial month value of 'January' is selected, the variable can be set to 15,000.

Hope that makes sense.

[#2]

Create a new Variables in qvw like:

=Only(Budget)

This work if a single value of Budget is possible, otherwise returns null

[Roop]

Create a New Variable and give it the value of:

=Sum(Budget)

This will ensure that is calculated if you select more than 1 month

Rupert

[buzzy996]

try this,

create variable and assign ur month dimension to that variable.

tht helps to automaticly the corresponding month value whenever u select a particular month.