3 Replies Latest reply on Feb 10, 2015 6:38 AM by Maarten Schuit

# Sum and percent bar graph

Hello,

I'm really struggling with something my boss requested. On the attached workbook, you will find a tab labeled "\$" and "%". What I'm trying to do is merge the two workbooks into one where the layout is the same, but each bar would contain the \$ amount AND %.

Is this where a bullet graph would be handy?

All help is appreciated!

• ###### 1. Re: Sum and percent bar graph

We can create only 1 view for each sheet, if you want to show multiple views, use the dashboard where can drag 2 reports & can place as we want.

In the Below image, I have added 3 reports i n the Dashboard.

I

1 of 1 people found this helpful
• ###### 2. Re: Sum and percent bar graph

Drew,

You can simplify the viz, if you use a parameter to decide if the bars are going to show the \$ or the %.

And also you can use it to colors (i.e. \$ defines the bar's size and % defines the color).

Side-by-Side bars would fit fine as well.

Regards,

Américo

1 of 1 people found this helpful
• ###### 3. Re: Sum and percent bar graph

Not a 100% sure if this is what you want, but it's possible to create something like the picture below:

or simpler:

Both are pretty simple to make, just let tableau calculate the sums and the percentages (using a table calculation)

1 of 1 people found this helpful