combining more than 1 dimension into single listbox
Is there a way we can combine more than one dimension into one list box. I have a situation wherein I have budgets for next 10 years as columns. Can I have all these 10 years combined into one list box for selection.
Particulars 2011 2012 2013 2014 2015 and so on
Please let me know if you have encountered similar requirement.
I have attached a sample file for your reference which has product data sales projections for future years. I need years to shown in a list box. The product data in real sense runs into 13,000 rows. Please suggest how to make year as a dimension directly in the script.
I am not able to see any data in the attached QVW . So i have created the sample data and used it. Attached the file for your reference. Let me know if you are looking for something else. Also please upload the sample data.
The description of what you want to accomplish is still a bit too unclear to enable me to give any advice. The QVW you attached is also empty, I would have expected it to have at least a chart object that would alter its presentation based on selection in the list box. So please elaborate a bit further on what exactly you are trying to do.
Please add a lisbox and a other objects in the QVW, and load it with data, to give a more apprehensive scenario. Also please attach this QVW here for our convinience.
If the data contains senstitive info, please use the scrambling function to make it unreadable.
That sounds a bit weird. Please make sure you are not running any kind of reduction on the QVW, even though I can not see how this would remove chart objects. If you are not able to provide the QVW, could you at least provide a screen shot of what objects you are having on your sheet?