-
1. Re: % of total from multiple data source
Rohan Malusare Jun 30, 2016 12:12 AM (in response to Jerlyn Toh)Hi Jerlyn Toh,
Tou are looking something like this,
Please check attached sample workbook.
Thanks and regards,
Rohan Malusare.
-
Superstore.twbx 305.9 KB
-
-
2. Re: % of total from multiple data source
Jerlyn Toh Jul 7, 2016 1:25 AM (in response to 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
-
3. Re: % of total from multiple data source
Chris Dickson Jul 7, 2016 1:35 AM (in response to Jerlyn Toh)Hi Cuiting,
would it be possible to attach a packaged workbook for us to look at for you?
-
4. Re: % of total from multiple data source
Aiswarya Sundaram Jul 7, 2016 1:44 AM (in response to Jerlyn Toh)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.
-
5. Re: % of total from multiple data source
Chris Dickson Jul 7, 2016 3:16 AM (in response to Jerlyn Toh)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.
-
6. Re: % of total from multiple data source
Jerlyn Toh Jul 10, 2016 11:07 PM (in response to Chris Dickson)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!