Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
A sample data set is : (empty cells = null data)
Required output is:
Can I achieve this using expression?
Currently I use "Before", but it doesnt work properly. It worked in August column, but went wrong in Dec.
And if you try with :
rangesum (before(sum(Your_indicator),1,2))
yes i mean using rangesum with before
exactly like that
May be try this
Before(Column(3))
Assuming that the Cumulative (A-B) is your third Measure
my measures are very dynamic, it will appear based on user's selected measure
so Cumulative (A-B) will not always be my third measure
May be use the expression label in that case....
Before(LabelName)
Hi
I dont think I can use that.
Here I attach my latest qvw.
it went wrong when I select only 1 month, the table will show all month data.
To fix this with selection, you will have to perform this action in the script... no way to do this on the front end (at least that's what I think)
Could you help me to fix it by using script?
since I'm not very familiar with it
Thanks
Can you check now if this meets your requirement