How it works…

In the script loaded at the beginning of the recipe, we set a variable called vDimension. The GetFieldSelections() function will return the values selected in the field we specify inside the brackets GetFieldSelections (Dimensions). The Dimensions field is simply a hardcoded list of specific fields in the data model. The code we wrote in the dimension field of the chart uses this variable value to set the dimension dynamically to whatever value the user picks in the list box we created.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset