Exchange dimension an calculated field

[schumi1980]

Hi All

I have calculate the active portfolio of our share of premium according to segments A,B,C,D like this:

sum({<Inception={'<=31.3.2012'},Expiry={'>31.3.2012}>} Premium)/sum(Total{<Inception={'<=31.3.2012'},Expiry={'>31.3.2012}>} Premium)as [April Premium]

sum({<Inception={'<=31.3.2012'},Expiry={'>31.3.2012}>} Premium)/sum({<Inception={'<=30.6.2012'},Expiry={'>30.6.2012}>} Premium) as [June Premium]

and I am able to present them in Qlikview like this:

However, I would like to present the evolution of our portfolio like this:

I need like to be able to stack the segments A,B,C,B for each expression.

Is there a way to do that in Qlikview or do I have to load the data completely differently?

Many thanks for your help.

Schumi

[Anil_Babu_Samineni · Accepted solution]

Sample attached? you can implement based on this?

[schumi1980]

Hi Anil

Many thanks, it works perfectly, and it is so simple.

Best regards,

Jan