7 Replies Latest reply on Jan 29, 2014 5:39 AM by Prashant Sharma

# 100% Stacked bar with three measures

Hi,

I have three measures and i want to display 100% stacked bar chart. i have found all the technique for two measure but with the three measures i have not any solution. i want to show measures percentage values that are all in 100% stacked bar chart. It should be sum up to 100% from all the three measures. i don't want to keep any other Dummy type field that make 100% percentage bar and overlaying other field, i just want to use that are three measures for making Stacked bar chart.

Thanks,

• ###### 1. Re: 100% Stacked bar with three measures

Hi Vipin,

Check this tread & hope this may help you. Combining several measures in one dimension

Warm Regards,

Prashant Sharma - India | LinkedIn

• ###### 2. Re: Re: 100% Stacked bar with three measures

Hi Prashant,

Thanks for your reply. but i want to show each stacked bar fit in 100% axis.I have also attached a sample workbook. i just want to show price 1,price 2 and price 3 values percentage sum up 100%.

Thanks,

• ###### 3. Re: Re: Re: 100% Stacked bar with three measures

Hi Vipin,

Check the attached file. This was created in Tableau 8.1, so if you are having older version then let me know.

Warm Regards,

Prashant Sharma - India | LinkedIn

• ###### 4. Re: 100% Stacked bar with three measures

Hi Prashant,

I am using Tableau 8.0. The file not opened in 8.0 version.please update the file according to Tableau 8.0.

Thanks,

• ###### 5. Re: 100% Stacked bar with three measures

Hi Vipin,

I have created 3 different calculated fields with the formula: -

sum([Price 1])/sum([Price 1]+[Price 2]+[Price 3])

sum([Price 2])/sum([Price 1]+[Price 2]+[Price 3])

sum([Price 3])/sum([Price 1]+[Price 2]+[Price 3])

Now Put these fields & Fruit dimension like below image: -

Price 1 is the first formula, Price 2 is Second & Price 3 is third one. Hope this may help!

Warm Regards,

Prashant Sharma - India | LinkedIn

• ###### 6. Re: 100% Stacked bar with three measures

Hi Prashant,

Thanks  Prashant. Your reply is very helpful. now my problem solved. thanks very much.

Thanks,

• ###### 7. Re: 100% Stacked bar with three measures

Glad to know that it helped!

Please, mark the thread as Correct and/or Useful Answer to keep the forum as clean as possible.

Warm Regards,

Prashant Sharma - India | LinkedIn