i want to let user be able to select different measures according different dimensions as they are using pivot table. i mean i want to let him to choose some of them(measures/dimensions) when he is using pivot table to make his preferred report. is it possible? if yes, how?
You can change dynamically change the dimension shown in a chart field by using a calculated dimension and a variable.
As a small example - imagine you have a table with three columns, A and B are dimensions and x is a measure.
A B x
----------
A1 B1 23
A1 B2 14
A2 B2 76
Create a variable (for this example we'll call it vDim). Create an input box that populates this variable using pre-defined values. The pre-defined values will be the names of the dimensions (e.g. A and B). This allows the user to choose a dimension.
Next, create a calculated dimension in the chart that uses the variable and dollar expansion to give the name of the selected value. The dimension definition would be something like: [$(vDim)]
Now, if the user selects A from the input box, they should see values of column A in the calculated dimension. If they change the value in the input box to B, they should see values from column B
A similar approach can be used for dynamic measures.
You can change dynamically change the dimension shown in a chart field by using a calculated dimension and a variable.
As a small example - imagine you have a table with three columns, A and B are dimensions and x is a measure.
A B x
----------
A1 B1 23
A1 B2 14
A2 B2 76
Create a variable (for this example we'll call it vDim). Create an input box that populates this variable using pre-defined values. The pre-defined values will be the names of the dimensions (e.g. A and B). This allows the user to choose a dimension.
Next, create a calculated dimension in the chart that uses the variable and dollar expansion to give the name of the selected value. The dimension definition would be something like: [$(vDim)]
Now, if the user selects A from the input box, they should see values of column A in the calculated dimension. If they change the value in the input box to B, they should see values from column B
A similar approach can be used for dynamic measures.
