Key Figures selection

[Former Member]

Hello,

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?

Thanks.

JLT

[Former Member · Accepted solution]

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.

Brian