Nprinting Pivot table issue with aggr

anirudhrao92 — Tue, 17 Mar 2020 20:46:29 GMT

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

topic Nprinting Pivot table issue with aggr in Qlik NPrinting

Nprinting Pivot table issue with aggr