Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Not applicable

how to display total sales in pivot table?

Hi,

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.

  

                         thank you,

Regards;

Madhu