DataStream Fetch() Method

[GreatDreamer]

I am doing grouping on Currency Type. eg. USD, GBP, EUR. I have created a variable "Total" ïn Data-Row that keeps total of previous "Currency Amt" values from previous dates and I would like do the following:

When the grouping changes (from USD, to GBP) I would like to reset and initialize the "Total" Variable for each type of "Currency Type" values (USD,EUR,GBP) and have the "Total" variable keeps total of previous "Currency Amt" values from previous dates. Also, the following variable "Total" is created in Data-Row and incremented in Fetch() method of DataStream. Question is do I modify the Fetch() method of DataStream to perform the increment of variable "Total"?

 

[milton747]

WOuld it help of you moved the Total var to global?
That way it can be saved without being impacted by the next row. Even an array of Total vars for each time period perhaps?