Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

New Contributor II

Nprinting Pivot table issue with aggr



i created a pivot table in qliksense and there the column total are AUTO so it is showing for overall in qliksense 

when i created pivot in nprinting 17 excel i had to choose either sum or count or average of below rows for column is there any thing possible without selecting aggr in excel for a column


Qlik values    Excel values

total-4.69       total if sum=4.02

1-2.32             2.32

2-1.7                 1.7


i want it to be 4.69 only like qliksense AUTO totals



Labels (1)