Qliksense : Pivot table

[Qlik2019]

Hi,

I am trying to create an attached view using value list in qlik sense.

1. How to calculate Net Frame 2 value using variable in table.. can we use column n. in expressions.

2, Since I am using value list how will I be able to add column "VAL".

 Above is the table i m creating.

Attached .qvf file and dummy data 

Thanks in advance