Pivot Totals and Pivot calculated dimensions

[Anonymous]

Hi All,

Following is the actual requirement in excel. The InsuranceCoverType is the existing dimension column.

Here I have 2 challenges to achieve in Qlikview.

1. Since 'Calculated Products' -is calculated based on the different filter conditions, I have loaded them separately with the specified conditions. Also, since there is a 'Total Products" in between. I have loaded ProductSet1,ProductSet2,Totals:products as Category and ProductA,B,C,D as SubCategory fields, which resulted in 2 separate pivot, tables which is fine with the business. Is there any alternative to build as per the actual requirement ?

2. I need to have the Totals for these measures (Volume & Sum insured) on the right side of same pivot or different pivot. How can this be achieved ?  

InsuranceCoverType	InsuranceCoverType1		InsuranceCoverType2		InsuranceCoverType3		InsuranceCoverType4		Sum Of all 4
Calculated Products	Volume	Sum insured	Volume	Sum insured	Volume	Sum insured	Volume	Sum insured	Volume	Sum insured
ProductSet1	74	$100.00	95	$200.00	74	$200.00	79	$100.00	322	$600.00
ProductsSet2	47	$200.00	30	$400.00	9	$400.00	31	$200.00	117	$1,200.00
Totals: products	121	$300.00	125	$600.00	83	$600.00	110	$300.00	439	$1,800.00
ProductA	53	$400.00	71	$800.00	58	$800.00	54	$400.00	236	$2,400.00
ProductB	12	$500.00	15	$1,000.00	9	$1,000.00	14	$500.00	50	$3,000.00
ProductC	1	$600.00	1	$1,200.00	1	$1,200.00	3	$600.00	6	$3,600.00
ProductD	7	$700.00	7	$1,400.00	5	$1,400.00	7	$700.00	26	$4,200.00