Showing/Hiding Crosstab Columns with Dimensions with CSS and Scripting

[former_member374033]

Does anyone have an example of how I can hid crosstab dimension columns in Design Studio 1.6 using CSS and scripting?

I'm using a radio button to display 1 specific dimension for all columns.  Depending on your dimension selected only that dimension and the measure will display in a crosstab.

Regards,

Donnell

[Former Member · Accepted solution]

Hi Donnell,

You could use following scripts to add or remove dimensions from a cross-tab. Assuming DS_1 is the datasource mapped to the cross-tab, I am removing a Region dimension and adding a Year dimension as follows:

DS_1.removeDimension("Region");

DS_1.moveDimensionToRows("Fiscal_Year");

Let me know if this works for you.

Thanks,

Nithya V

[TammyPowlas]

Have you looked at / considered David's blog on a similar topic: