How to Show Grand Total in Tableau

preview_player
Показать описание

In this example I have region category subcategory and sales. I'm showing a cross tab. I've added a grand total to the columns and a grand total to the rows.

I've duplicated my sheet in Tableau and I have a cross tab of sales by category subcategory and region. how do I add Grand totals? Click on the analytics button you have a totals option drag it into the middle of the screen. I can add column Grand totals and I can do the same thing to add row Grand totals.

You can also add totals by clicking analysis totals and show row and column Grand totals. You also have some options like showing totals on the left or showing column totals on the top.
Рекомендации по теме
Комментарии
Автор

Thanks a lot! I couldn't find this before for a few days but You're help me!

alexpokr
Автор

How to color code based on grand total?

Me_out_of_office
Автор

"Cannot turn on Grand Totals for discrete measures". I swear Tableau makes everything difficult on purpose. Just add up the numbers!!!!

OuchLOLcom