Switching Dimensions with $Field

[#1]

Hi there,

I'm trying to get a chart Dimension to be variable based on a table selection. Because the various 'dimensions' can change or be added to frequently I want to avoid creating a 'conditional dimension' for every one, which is how I've done it in the past.

The image below shows how far I've got - but it isn't quite working. Any suggestions? I want it to look like the chart at the bottom, with the option of changing.

Thanks very much,

[MK_QSL]

Use Calculated Dimension

=$(=GetFieldSelections([$Field]))

[simondachstr]

Try ='$($(='=Only($Field)'))' as dimension.

[tresesco · Accepted solution]

Or, simply =$(=[$Field])            // works when single value to be selected

For multiple selections you have to use a bit of tricks: all fields in the dimnesions with conditional enablement.

[simondachstr]

Good one! I guess I lost myself in scripting