5 Replies Latest reply on Jun 5, 2017 9:27 AM by rob place

Displaying sum of stacked column using calculated table

rob place Jun 4, 2017 3:33 PM

Hi,

I am pretty new to table calculations and am trying to display a sum value of each stacked column. As you can see below, it would be great to add the columns to show $500, $300, $400, and $600. (Granted it's not the perfect demo as 3 of the columns are only one value, but my real data is more complicated).

Here's the data in table form. So essentially I want to add up each campaign's

I've attached the workbook for use. Any help is so appreciated.

Thanks,

Rob

campaign attr for board.twbx 62.1 KB

1. Re: Displaying sum of stacked column using calculated table

Chris McClellan Jun 4, 2017 5:06 PM (in response to rob place)

It's usually as simple as creating a dual-axis - one with color, one without (ie not having Account on Color) and syncing the axes and you're done.

Your data is a bit different though (the table calc ?) so as soon as I remove Color the totals for each bar changes.

Hopefully this is enough to get you going in the right direction though.
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Displaying sum of stacked column using calculated table

Zhouyi Zhang Jun 5, 2017 12:16 AM (in response to rob place)

Hi, Rob

You can create a calculation field to replace the one with the Label and set up the table calculation as shown below
Hope this could help

ZZ
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
3. Re: Displaying sum of stacked column using calculated table

rob place Jun 5, 2017 7:26 AM (in response to Zhouyi Zhang)

Zhouyi, is there any way to put your value on a dual axis as Chris mentioned so it's not embedded in the stacked column? Can you share the workbook with me?

Thanks,
Rob
Like Show 0 Likes(0)

Actions
4. Re: Displaying sum of stacked column using calculated table

Abhishek Yadav Jun 5, 2017 8:12 AM (in response to rob place)

Hi Rob,

You can use a reference line for each cell and use the measure for which you want to display the sum and based on that it will display the value on top of each bar. Please check the below screenshot.

Regards,
Abhishek
Like Show 0 Likes(0)

Actions
5. Re: Displaying sum of stacked column using calculated table

rob place Jun 5, 2017 9:27 AM (in response to Abhishek Yadav)

Thank you all for your insight, I think they were all correct answers. I ended up using Abhishek's solution as show below:
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Displaying sum of stacked column using calculated table

1. Re: Displaying sum of stacked column using calculated table

2. Re: Displaying sum of stacked column using calculated table

3. Re: Displaying sum of stacked column using calculated table

4. Re: Displaying sum of stacked column using calculated table

5. Re: Displaying sum of stacked column using calculated table

Actions

More Like This