I have a one requirement where i need to get a column which contains value by which we get after putting cumulative property to key figure. E.g. I have a below output for existing query.
But i want to change this output to
row1 col1 col2
ABC 10 10
AB1 20 30
AB3 20 50
AB4 30 80
We can do this by making col2 as a cumulative value, but i don't want this in just for display purpose i want to use this information in Other formula so i want this value available for use in other formula/calculations