Hi,
The given example is a simplified version of the problem. I dont need a solution for the actual task - so please no workaround answeres - Just is this possible, and why not?
I have a Pivot Table with Months as its Columns(numeric).
i've set a variable in the Document Options:
vShowParam: sum({<Month={$1}>}Value)
The Variable is called inside the Chart:
$(vShowParam(Month))
Now, it seems like the variable will always be expanded/evaluated outside the context of my chart.
Meaning Month is independent of the char Column 'Month' at the time of evaluation. So Month is always 12
I tried the following:
=$(vShowParam($(=num(Month))))
Results to: vShowParam: sum({<Month={-}>}Value)
=$(vShowParam($(=num(max(Month)))))
Results to: vShowParam: sum({<Month={12}>}Value)
=$(vShowParam(num(max(Month))))
Results to: vShowParam: sum({<Month={num(max(Month))}>}Value)
Is it possible to have a Parameter resolve inside the Context of the Chart before evaluating the Variable?
My current solution is (works, but there must me a clearer Solution!):
if(Month = 1, $(vShowParam(1))
,if(Month = 2, $(vShowParam(2))
Any Ideas?