Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have data as under.
load *
inline
[exp,amt
Gros, 20
Travel,50
Ent,20
others,10
];
I want to plot a chart for total exp is 100, on each expense i want to show % of total exp by category
Gros is 20% of total expense,
Travel is 50% of total exp
Please help.
Thanks..
Here it is with different colors and text on axis.
Use 'exp' as your dimension and '=amt/sum(all amt)' as your expression. On the 'Number' tab click 'Show in Percent'. Hope that helps.
Attached is the sample to display both Amount and Amount %. I hope it helps.
Thank you, i used that. It works,
I am sorry, I was not clear. I want to show bar with different color of %. all bar has same color for total and then % of color will be different based on category.
Lets say total amt barr is blue and i eant to change 50% bar to green for travel category. so my bar will look half green and half blue. I am trting with back ground color, but some how not getting it.
Seems quite simple.
In Dimension, you select 'exp'
In expression, use this formulae: amt/sum(all amt). It would display in decimal value. If you want in %, go to Number format and select 'Fixed To' and enable the Show in Percent(%).
Please check.
Thank you, i used that. It works,
I am sorry, I was not clear. I want to show bar with different color of %. all bar has same color for total and then % of color will be different based on category.
Lets say total amt barr is blue and i eant to change 50% bar to green for travel category. so my bar will look half green and half blue. I am trting with back ground color, but some how not getting it.
Will something like this work?
Thanks,
I think this is what i wanted but value on data point doen't show for individual. I am not sure may be it is hiddle under becuase of stacked char. Am I missing anything here.
PLease let me know.
Here it is with different colors and text on axis.
thank you so much. I wanted to show it at data point but shome how it is not showing.