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
Let me formulate what I think you want.
Your query (SO & material in rows and KFs in columns) result is shown in BEx Analyzer (Excel). Because usually there are too many data for chart presentation, you want to limit it by choosing SO and material. For it you want to place two combo boxes into sheet and let users to select SO and material from the boxes. The result of this selection should be reflected in a linked chart. Is it a proper situation?