Discussion Board for collaboration related to QlikView App Development.
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.
Thanks in advance.