Data Fields Drop-Down Grouping Challenge

[#1]

I have a problem that I am not able to address for quite some time now. I have named this problem as – Data Fields Drop-Down Grouping Challenge.

Background: I have 12 data fields (all of them in single table- excel sheet) – P1, P2, P3 , P4, C1, C2, C3, C4, M1, M2, M3, M4

P - Population, C - Companies and M – Money

Challenge: Now I have to create a bar graph in such a way that there is a drop down box right above the bar graph and the drop down contains following option- Population, Companies and Money. When I select ‘Population’ option from the drop down box then the bar graph should show only P1, P2, P3, P4 (population data fields) on the graph. When I select ‘Companies’ option in the down-down then the graph should only show C1, C2, C3, C4 (companies data fields). And when I select ‘Money’ option then only the M1, M2, M3, M4 ( money data fields) should be displayed on the bar graph.

Will it be possible if anyone can suggest step by step method to get this type of grouping.

[#2]

By using Cross table method you can find solution.

First:

Create 3 table instead of 1 table using resident method. first table fields are P1,P2.P3,P4,Type. Second table fields are C1,C2,C3,C4,Type. Third Table fields are M1,M2,M3,M4,Type

In field "Type" give proper value based on table like 'Population','Companies' and 'Money'.

Now all 3 table into final qvw.. You can use "Type" field as list box.

Hope its will help u..

[#3]

Sorry I forgot to mention main step..

Using cross table convert all columns like P1,P2,P3,P4 into row... Keep this field name same for all 3 tables.

If you can't understand this method.. Kindly post sample data..    

[flipside · Accepted solution]

If you are using QV11, then you can do the following ...

1. Create an island table with one field (eg DataGroup) in script to hold your Group names (Companies, Money and Population) and create a list box.

2. Add ALL your expressions to your single bar chart.

3. Tick the conditional show box for each expression and add =Only(DataGroup)='Companies' (or Money or Population as releveant).

Your chart should show the relevant expressions as the user selects the group.  You can even change the 'All expressions disabled' message on the General tab in properties to a more user-friendly message such as 'Please select a Data Group' or something.

flipside