Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Contributor II

In Pivot Table display two times "Total"


I have prepared one pivot table which contains Four dimensions, and MTD and PYTD expressions and I have do pivoting with one dimension called "Month".

In Presentation tab I have marked "Show Partial Sums" for all dimensions,

After than when I look into Pivot Table, it displays Two times Total in Partial sum of Month as like as below.

Need only One time Total as per below.


In Advance.

1 Reply
Valued Contributor II

Re: In Pivot Table display two times "Total"


for me, it means that you have 2 different values for salesrep, so 1 total line per each