This content has been marked as final.
Show 5 replies
-
1. Re: Displaying sum of stacked column using calculated table
Chris McClellanJun 4, 2017 5:06 PM (in response to rob place)
1 of 1 people found this helpfulIt'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.
-
2. Re: Displaying sum of stacked column using calculated table
Zhouyi ZhangJun 5, 2017 12:16 AM (in response to rob place)
1 of 1 people found this helpfulHi, 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
-
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
-
4. Re: Displaying sum of stacked column using calculated table
Abhishek Yadav Jun 5, 2017 8:12 AM (in response to rob place) -
5. Re: Displaying sum of stacked column using calculated table
rob place Jun 5, 2017 9:27 AM (in response to Abhishek Yadav)