are this ({?Period}, NETPERD1, NETPERD2 , NETPERD3, NETPERD4, NETPERD5 , NETPERD6 , NETPERD7, NETPERD8 , NETPERD9, NETPERD10, NETPERD11, NETPERD12 )
separate fields or one field?

i dont see a simple solution for this if you know some SQL you could try to write a command like

select NETPERD1 as Type_id, value
from databasename.dbo.tablename
union all
select NETPERD2 as Type_id, value
from databasename.dbo.tablename
union all
select NETPERD3 as Type_id, value
from databasename.dbo.tablename
...
so that you could have it as a single field then the rest of it should be easy.

I'll throw in my 2 cents...

I agree with DBlank, I was going to structure my addition slightly differently, but the effect would be the same...

As is my usual response, if you can write a stored procedure, you should be able to accomplish all your goals in a much simpler fashion. Meaning that your stored procedure could return just the data from say period 7, and as an additional column the sum of all prior periods.

Although in reading the various responses, you are not filtering any data, just only displaying the value of the current period, but you want a running total of the periods...so DBlank's solution should work. The only caveat is that you won't be able to SUM his formula...but there are ways around that.

HTH