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.
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
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.
Refer to the attached sample output. tks
Thanks for replied everyone got the output.
Retrieving data ...