Create dynamic report based on selections of dimensions

[george456]

Dear Community

I need to create a report builder. What I have done is to create a in line load of possible dimensions.

I then created a list box to show dimensions the users can choose from

What needs to happen next is with 'enabled condition' in dimensions to toggle between dimensions . The users must thus choose and the relevant dimensions must be displayed in the report

The syntax I used is:  GetFieldSelections(Dimensions,',',1)>0, but it is not activating the dimension as I intended

Can you please help

Regards

[sunny_talwar · Accepted solution]

For activating a specific field... let's say Region... you should try using this

SubStringCount('|' & GetFieldSelections(Dimensions, '|,|', 1000000) & '|', '|Region|') = 1

[george456]

Many thanks. I am delighted by your solution. 

Regards