I created pivot table in qlik view , i took country ,city dimensions, after wrote expressions like this 1.sum( sales)
2.sum(sales) / sum( Total sales) 3.sum(sales)/sum(total<Country>sales).then after I selected sub totals option. after I selected sub totals option for country and city.then the pivot table showed sub totals in table.in this scenario I want to display like this.If i select city in list box the pivot table show city total and the entire table total does not change in pivot table. is it possible in Pivot table.Tell me out How to display city sub total total in pivot table at the same time I do not want change the entire table total.
