Dear all can you please help me on this issue. I have for example a Measure which is called “IndicatorValues” which contains several values, also a Dimension which is called “Indicator” and contains the corresponding names for these values. I want to create a calculated field which reflects the Average of all selected “Indicator”. For example in the filter if I select only 10 out of 20 of “Indicator”, the calculated value should be only for those 10.
You can do this by creating a calculated field similar to the following:
Depending how your view is set up you may need to change for the calculation is being computed. To do this right click on it and select Compute Using..>the appropriate selection.
Hope this helps!