Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I need to subtract the two rows and the result should be feed to another column.
I have attached my Data in excel, Please any one give me the solution for attached data.
thanks,
Try a chart inter record function, Above():
=Rangesum( Value, -Above(Value) )
In case you have more than Value for each Month, you might need to add Sum() or Avg() or whatever you expression is for value
=RangeSum(Exp4Value, -Above(Exp4Value))
Thanks for your valuable reply
But using above expression i did't getting my result. can you please give me a example .qvw or .qvf use the data which i have attached.
Hi,
Refer to the attached sample output. tks
Thanks for replied everyone got the output.