Forum Discussion

NitishKrishB's avatar
NitishKrishB
New Contributor II
6 hours ago

Is there a way to hide/show columns based on combo box value selection?

Here is the scenario: I have a Combo Box that holds value "Summary View" and "Detailed View". 

Based on the combo box selection value in the dashboard, the CV columns needs to update dynamically in CV. Summary View should have all columns except "Variance" Column. 

And when Detailed View is selected, This should have all columns including 'Variance' Column. 

The tricky part is that these are shared columns from another CV. And we already have a formula for 'Variance' column in XFBR. 

In Short: When Summary view is selected, Variance column should hide and when Detailed View is selected, all columns should show up! 

Any idea or a suggestions are greatly appreciated! Thanks. 

Cube View
Dashboards
Parameters
Reports

1 Reply

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    3 hours ago

    Hi NitishKrishB: this can be achieved with standard header formats and a simple conditional logic check.

    In the variance column of your cube view > Header Format:

    If (|!YourComboBoxParameter!| = 'Summary View') Then
    IsColumnVisible = False
End If