Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Highlighted
anirudhrao92
New Contributor II

Nprinting Pivot table issue with aggr

Hi,

 

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

 

Thanks 

Labels (1)