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