Key Figures selection
I need to create a query that would prompt the user to select the Key Figures group to be displayed in the selection screen. I have 10 Key Figures that can be grouped in 2 areas. The user would select one area or the other and see a different set of KF.
Anyone has an idea on how to do this?
You can create a hiearchy and include the two sets of key figures in different nodes ... the user can then select which node to look at ... or both.
Or you can create a VBA button that hides one group of columns while the other is displayed and vice versa.