Display Color Dimension as % in Stacked Bar in SAC

[gauravd86]

Hi Experts,

I need to display the Color dimension as a % instead of a number.

For ex - For Sales manager Gary Dumin... Instead of showing as 4,2,2....can i show it as 50%, 25%, 25%

Is it possible to show in % ?

[Tobias_Mueller · Accepted solution]

Hi,

This is not possible in our standard stacked bar chart.
I would strongly recommend to review chart design. The way you are seeking to do it is not very intuitive to understand for the enduser. As soon as you show percentage values on the bars, it is not possible to compare between sales managers. 50% on one bar has a different size than 50% on the other bar. It is hard for our mind to understand it.

I would as well recommend switching to a 100% chart or if you first want to visually determine which are the sales managers, which sold the most products, i would do this as the first step and then use linked analysis together with the distribution over different product areas in a second chart.

BR,

TM

[JBARLOW]

Hi gauravd86

One workaround would be to use a calculated measure,
I created a calculated measure named 'percent' using the formula:
%GrandTotal(["BestRunJuice_SampleModel":Gross_Margin] )

This gives a chart that looks like this

//edit - sorry it's not actually what you asked for as it gives each product's % of the grand total -- not per Sales Manager

[gauravd86]

avsalynin rohitchouhan thank you for the ans... tried this but the issue with this is I am not able to get variable bar length as shown with my example.....after selecting "show chart as 100%", all the bars are scaled to 100%.

It is possible to have variable bar length but instead of no can have % ?

[rohitchouhan]

Yes,

1. Click on Chart, go to Designer
2. Select Comparison as Stacked Bar/Column, There one check box will appear as Show Chart as 100%
3. Check this box, You will see your records in percentage
4. Save it and run

[avsalynin]

gauravd86

yes,you can.