I have two characteristics hierarchies (sales organizations and material) defined as rows and 3 key figures (sales quantity, amount and value) in column format for a specific queries.
Now I want to design two combo box, respectively for two characteristics hierarchies. say combo box 1 (Sales organizations) for hierarchy one and combo box 2 (Material) for second hierarchy.
I want the combo box 1 should contain the unique values of sales organization hierarchy and combo box 2 should contain the unique values of material hierarchy.
Now depending upon the selection value of sales organization level and material combination, an ineractive chart should be displayed to show the corresponding values.
I think we need to use VB macro to do the above. Please help