I am attaching a dashboard requirement. How do I organize data in Excel ?
I am worried about the radio buttons filtering for all the regions. Charts will change the data based on the selection at the radio buttons.
Any help will be appreciated.
Requirement.zip (156.0 KB)
Developer_Designer (BOB member since 2009-08-09)
I would think that would be a good thing… it appears as though the region radio buttons should affect the charting… but, I may not understand the visualizations and display objectives.
Must be executive boards/presentation… they give the “glass is half full” view… 
It leads you to do your own math to determine the bad…
Executives want the state of the union… managers want “what’s broke… how do we fix it?” boards.
Use the radio button selection to move a sub array of data picked into a block to be consumed by the components… match and index.
datawizard (BOB member since 2015-01-20)
You are right. This is executive level dashboard. Radio button will affect the entire chart. This is also my first dashboard to build. Really struggling.
Developer_Designer (BOB member since 2009-08-09)
This looks like an interesting project. What version of Xcelsius are you working on?
rainmaker_ 
(BOB member since 2010-10-28)
Business Objects Dashboard 4.0. And data will be only based out of excel. Later release may be out of BEx Query.
Please let me know if you could help.
Developer_Designer (BOB member since 2009-08-09)