I'd like to share this problem with you: I have a bar chart where X axis is month and where there is only an expression which has the following form:
2571+(66/4)*(subfield(num(month)/3,',',1) ).
And it work perfectly, but I would like to visualize all months <= month selected, so I tought I should use a set analysis like that Sum({<month={"<=$(=max(month))"}>} ... ) but it didn't work ... why? I even tried just sum({<month={"<=$(=max(month))"}>} 1) but values were so strange...Can you help me find a solution?
Ok, thank U Manish. I found out where the problem was: I have to admit that the situation I illustrated it was placed in a wider scenario, where month was loaded more than once, so what happened was that the constant values I introduced were counted as many times as each month was loaded... so the so-called "strange values" appeared! Then I paid attention to that fact and I introduced DISTINCT in my sum... and now everything works perfectly!
