Repeat the same value in the column issue

[#1]

Docu ment No	Material	StartDate	EndDate	Year	Period	NetSales	RunningPeriod	test
214500008	test1	09/09/2009	08/09/2011	2009	006	12,005.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2010	003	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2010	004	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2010	006	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2010	007	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2010	008	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2010	009	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2010	010	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2010	011	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2010	012	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2011	001	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2011	002	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2011	003	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2011	004	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2011	005	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2011	006	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2011	007	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2011	008	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2011	009	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2011	010	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2011	011	0.00	24.00	0.00
214500008	test1	09/09/2009	08/09/2011	2011	012	0.00	24.00	0.00

I have a reporting requirement to Get the value from (Netsales column /Running Period column)= 500.21and update the value to test column -I have to update the 500.21 repeated same value for test column for all rows.

I have tried Range sum(above) and below function .

Expecting result

Document No	Material	StartDate	EndDate	Year	Period	NetSales	RunningPeriod	test
214500008	test1	09/09/2009	08/09/2011	2009	006	12,005.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2010	003	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2010	004	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2010	006	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2010	007	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2010	008	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2010	009	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2010	010	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2010	011	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2010	012	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2011	001	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2011	002	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2011	003	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2011	004	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2011	005	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2011	006	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2011	007	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2011	008	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2011	009	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2011	010	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2011	011	0.00	24.00	500.21
214500008	test1	09/09/2009	08/09/2011	2011	012	0.00	24.00	500.21

Advance thanks for your help .

[#2 · Accepted solution]

Solution : Created variable1 with (sum of netsales) and called the variable1 in the chart expression.

It works.