topic Re: How to create a total column in a ident pivot table? in QlikView

How to create a total column in a ident pivot table?

Tue, 27 Jun 2017 07:31:14 GMT

i have an iden pivot table and i want a column whit the total of hrs and ftes in the right, i try everything and dosen´t found well, any idea? sorry for my english. i attached and example

Re: How to create a total column in a ident pivot table?

ahaahaaha — Tue, 27 Jun 2017 08:35:47 GMT

Hi,

If I understood you correctly. Try setting flag "Show partial sum" at the desired dimensions/expressions.

Regards,

Andrey

Re: How to create a total column in a ident pivot table?

prma7799 — Tue, 27 Jun 2017 08:56:59 GMT

Go to Presentation > check Show Partial Sum

Totals in a PivotTable

Re: How to create a total column in a ident pivot table?

Tue, 27 Jun 2017 10:29:11 GMT

i´ve do it but i shows de total of each month, i want a column at the end with the total of all months of a row

Re: How to create a total column in a ident pivot table?

Tue, 27 Jun 2017 10:31:01 GMT

i´ve do it but it dosen´t make a column at the end with the total of the results of all months in a row, i don´t know if the problem will be in the expresions o dimension that i have to select, its hard for me

Re: How to create a total column in a ident pivot table?

Tue, 27 Jun 2017 10:39:09 GMT

if i do it de column appears at the begining if i flag partial sums down it appears at the end but mi field comes from that:

country

city1

city2

to that:

city1

city2

country

also the ftes doesn´t sum properly

thanks for the answers