Hi All, I need some help here on calculating % of a total. I have done a calculated field to calculate the sum of a different field in each data source. With that, I stacked all the aggregated data into a stacked bar and I would like have a % of each bar over the total of all the bars. Is that possible? and I'm still using desktop version 9.0.
Hi Jerlyn Toh,
Tou are looking something like this,
Please check attached sample workbook.
Thanks and regards,
Rohan Malusare.
Hi Rohan Malusare,
Thank you for the reply. But that is not what I'm looking for. For my case, the calculation is all from different data source. So I stacked all the aggregated measure. So for example C, its 218,669. I want to get the % of C over the total of the stacked bar. Is that possible?
Thanks
Cuiting
Hi Cuiting,
would it be possible to attach a packaged workbook for us to look at for you?
Hi,
Just a quick thought not taking it away from others
You can move labels around. so click on the 'C' label and move it above the bar.
I'm not quite sure about how dynamic this is i.e. if your bar height changes what would happen to the label; but give it a shot.
Hi Cuiting,
unfortunately i have had a play and can't produce the outcome you want, i'm sure you know (as you mentioned it in your post that you are 9.0) that a simple union available in 9.3 would fix your issues and make this a very easy calculation to do.
Hi Chris,
Okay. Thank you for the help. Unfortunately I am not able to use 9.3 for the time being. But will definitely explore that once I get the new version. Thanks!