Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Create a new Variables in qvw like:
=Only(Budget)
This work if a single value of Budget is possible, otherwise returns null
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
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.