Qlikview query to find addition of field values in pivot table.

[shrusrkt]

Hi everyone,

henri-lo‌

sahadevpatil‌

brijeshfofadiya‌

City, Agent Name, GC Code, Product, Business_Type are in Dimension.

In product--> Motor, Health, SME are the field-values.

In Business_Type --> New, Renewal field-values are there.

I want to add new for all products  also I want to add renewal for all products.

I had tried do it in pivot table--> presentation tab --> partial sum, however I got the total for Products,  I dint get total_New for Products, & total Renewal for Products.

Please refer the attachment below.

Please help.

Thanks in advance.