I have a variable as below.
If monthnumber=1 then 177.14
Elseif monthnumber=1 then 337.14
Elseif monthnumber=1 then 514.28
Crosstab below in attachment.
var1 is a running sum for each month.
If user selects Month 1 in Input control. Amount/177.14...
If user selects Month 2 in Input control. Amount/337.14 and so on.
When I remove month from crosstab. I get #multivalue error. Please see attached.