Filtering Key Figures/Columns in a Cross Tab Component

[Former Member]

Hello All,

I am creating a P&L Statement for Better/Worse comparisions, and I have to show only three columns at a time based on User Drop Down Selections.

Here is my Bex Query Out put looks like.  The Rows part is "Structure" and Columns are "Cell Restrictions".

Now, the CrossTab component has to show only Two columns at a time, based on user selections. Here is my desired output. User will Select either ' Avg' Rate or 'End Rate'. Based on that selction, Actual's will show in the First Column and based on Selection from Second DROPDOWN for Budget/Forecast/PY, the Second Column has to be displayed.

Is there any DropDown Component or CrossTab Component Options are there to Filter the Columns based on User Selections ?

Appreciate your help. This is the Crucial Chart for the whole Dashboard.

Thanks,

Sonti.

[Former Member]

Hi Sonti,

What are you using to select the different Views?

If you are using a selector components, there you can directly filter the Data Source which is assigned to the Crosstab.

Regards,

Fazith Ali Z.

[TammyPowlas]

Did you try the filter panel component to select the Key Figures?  See example below:

[Former Member]

Hi Tammy,

Thanks for your quick reply.

Can it be done dynamically without the User touching it ? My Cross Tab has to show values based on the Selctions. But, I couldn't find the code to restrict Cross Tab data.

I have to code for Dropdown box --> On Select, to check / Un check the KF's in the Filter Panel Component. And in Filter Panel Comoponent, --> On Select, DATASOURCE.setFilterExt("KF1", "KF2").

And assign the data source to Cross Tab.

Please correct me if I am wrong.

Regards,

Sonti.

[TammyPowlas]

With the filter panel, the user has to touch it (based on my experience), and there is no code involved.