Pivot Table - Column Totals

[timpoismans]

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

Thanks in advance.

Kind regards,

Tim

[prat1507]

Use rangesum()

Regards

Pratyush

[timpoismans]

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]

turn on "Show totals" under dimension.

[timpoismans]

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

[agigliotti]

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

[timpoismans]

Yeah, thought so.

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

[agigliotti]

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

[timpoismans]

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]

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