Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use rangesum()
Regards
Pratyush
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.
turn on "Show totals" under dimension.
That gives me a Total of all the rows, for that specific column, the opposite of what I need.
what you need is not possible because you get totals for all your measures.
Yeah, thought so.
Any other way I could achieve this outside of a Pivot Table?
yes of course you can use a text box and type there your sum aggregation ex. Sum(measure1) + Sum(measure2)
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?
yes maybe but i think you have to use only one measure in your table object.