Before function in Pivot table with ValueList as one dimension

[#1]

Hi All,

I have a table in QlikView with three columns

Week, GrossPremium, NetPremium

W1, 1000, 800

W2, 2000, 1500

I need to produce output in a QlikView pivot chat as below, which shows the movement of premium week on week

Week                                        W1                                          W2

                                  Value             Movement         Value                 Movement

Gross Premium         1000              -                         2000                  1000

Net Premium             800                -                         1800                   700

Movement is calculated by subtracting the current week numbers with previous week numbers. I have used a valuelist fucntion to create additional dimension with values 'Value' and 'Movement'. I don't want to create these columns in my script for performance issues (i have a huge table with a number of variables to compare (not just gross & net premium).

Attached is the sample QVW.

Could you please help me with this?

Thanks in advance.

Murali