Pivot Table Sorting Issue

[Anonymous]

Hi All,

         we want to display below mentioned data into single pivot table with a column name called produc name which is either Fund Or Cap depending on Vehilce along with the sort order mentioned in respecitve columns either  Fund Sort Order   Or .Cap Sort Order. depending on vehicle. Please find the qlikview app as an attachment. Some how this sort is not working after we configure sort using expression.

Vehicle	Group	Cap	Fund	Fund Sort Order	Cap Sort Order
MF	offer1		Fund1	1
MF	offer2		Fund2	2
MF	offer1		Fund3	3
MF	offer2		Fund4	4
MA	offer3	Cap1			5
MA	offer3	Cap2			6
MA	offer4	Cap3			7
IA	Offer5	Cap5			8
IA	Offer5	Cap1			9
IA	Offer5	Cap4			10
INS	Offer6	Cap1			11
INS	Offer6	Cap4			12

Dimensions: I have used are below:

Vehicle

Group

=if(Vehicle ='MF',Fund,Cap)

Sort Order All  the dimensions:

= if(Vehicle ='MF',[Fund Sort Order],[Cap Sort Order])

Sort order is not working as per expected.. Please find the attached qlikview app along with the data in excel.