11 Replies Latest reply: Sep 28, 2017 6:47 AM by Andrea Gigliotti

# 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:

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

Kind regards,

Tim

• ###### Re: Pivot Table - Column Totals

Use rangesum()

Regards

Pratyush

• ###### 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.

• ###### Re: Pivot Table - Column Totals

turn on "Show totals" under dimension.

• ###### Re: Pivot Table - Column Totals

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

• ###### Re: Pivot Table - Column Totals

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

• ###### Re: Pivot Table - Column Totals

Yeah, thought so.

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

• ###### 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)

• ###### 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?

• ###### Re: Pivot Table - Column Totals

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

• ###### Re: Pivot Table - Column Totals

I'm taking select parts out of my total through set analysis with every measurement, so if I use the same measure without the set analysis, I should get the total.

That might still differ from the total if I'd sum all my columns as there might be a calculation error in the measures, but if there's not, it should work like that.

• ###### Re: Pivot Table - Column Totals

let's try and let me know if you need some help.