Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I am using a pivot table and I have to replace Initial Value by Last value of the previous row at front end?
Any function?
Example:
Date Initial Value Sales ClosingValue
Apr-14 50 10 60
May-14 60 30 90
June-14 90 -20 70
like this.......at front end
Regards,
Balraj
?????
Can you explain your requirement with sample data?
already mentioned in example, What I need to get?
Do you want to calculate ClosingValue (= Initial value + sales)?
above(ClosingValue)
or look for chart inter record functions in Qlik online help