Custom Cross table

[#1]

Hello,

I have the following cross table in Qlikview :

The expression is : sum(Active_G)

I need to have the cross table like this :

It's calculated by the way:

for each row; cell=sum(Active_G) / { first cell of the row }

example:

C2=255969/255969             D2=233454/255969        E2=216060/255969 ...

C3=155121/155121             D3=138034/155121        E3=125666/155121 ...

Could you help me please to get this cross table.

PS: I attached the qvw file with data, it can helps you.

Regards,

Yacine

[#2]

Sorry for bad quality of the pictures; you can clic on it to get it in a better quality.