PIVOT TABLE Front end expression required

[Anonymous]

Hi All,

Part        No

Year

Part Desc.

Supplier Code

Plant Code

Release Date

28-Mar

4-Apr

11-Apr

18-Apr

25-Apr

2-May

9-May

16-May

23-May

A

2016

XYZ

AAA

AAA1

3/28/2016

T

S

4/4/2016

T1

4/11/2016

4/18/2016

4/25/2016

5/2/2016

5/9/2016

5/16/2016

5/23/2016

S1

above is pivot table where in forecast date has been dragged to the top so that each forecast date acts as a column

Suppose all the cells are filled with values.

Part number A has been selected in the application

Now i want to bring value from cell S of release date 28/03/2016 and forecast date 23 may to the cell T of release date 28/03/2016 and forecast date 4 april

Similary i want to bring value from cell S1 to T1.

The logic should work dynamically in case release week is selected from 3/28 to 9/5

In that case

bring value from cell  of release date 28/03/2016 and forecast date 9  may to the cell of release date 28/03/2016 and forecast date 4 april

Regards,

Jatin

[Anonymous]

What is your intention of doing this ?

[Anonymous]

Once i get the required value in the target cell, i will doing subtraction of that cells value and the new broughtin value and get the difference