I would like to accumulate Metric1 in Table 1 (attached) in the Load Script across the Period field for each Release. However upon doing so i would also like to set the first Period for each Release to start at 1 and then increment by 1. So for Release 2009, Period 2009-02 would become 1, Period 2009-03 would become 2 and so on. For Release 2010 Period 2010-03 would become 1, Period 2010-04 would become 2 and so on.
Can anybody suggest a way of doing this in the load script please. I have a larger / wider requirement than this so i cannot simply use the full accumulation within the Chart so this must be done in the creation of the dataset.