Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

timpoismans
Valued Contributor

Pivot Table - Column Totals

In a pivot table,

is there a way to create a single column that shows me the total value of all columns, without splitting them by measures?

For clarification:

this is my current situation:

Pivot Table Total 1.png

This is the situation I want to achieve (Pardon the aweful drawing skills):

Pivot Table Total 2.png

Thanks in advance.

Kind regards,

Tim

11 Replies
prat1507
Valued Contributor

Re: Pivot Table - Column Totals

Use rangesum()

Regards

Pratyush

timpoismans
Valued Contributor

Re: Pivot Table - Column Totals

How does this exactly work in a pivot table?

As you can see, the total should be outside of the month column.

What I want to achieve is a Total of all the columns, for that specific row.

agigliotti
Honored Contributor II

Re: Pivot Table - Column Totals

turn on "Show totals" under dimension.

timpoismans
Valued Contributor

Re: Pivot Table - Column Totals

That gives me a Total of all the rows, for that specific column, the opposite of what I need.

agigliotti
Honored Contributor II

Re: Pivot Table - Column Totals

what you need is not possible because you get totals for all your measures.

timpoismans
Valued Contributor

Re: Pivot Table - Column Totals

Yeah, thought so.

Any other way I could achieve this outside of a Pivot Table?

agigliotti
Honored Contributor II

Re: Pivot Table - Column Totals

yes of course you can use a text box and type there your sum aggregation ex. Sum(measure1) + Sum(measure2)

timpoismans
Valued Contributor

Re: Pivot Table - Column Totals

Yeah, of course that works xD

But I should be able to use a straight table as well if I keep the month out of the table and make the users select the month(s) they want to see, right?

agigliotti
Honored Contributor II

Re: Pivot Table - Column Totals

yes maybe but i think you have to use only one measure in your table object.

Community Browser