We are going to create two kinds of reports:
...
| Info |
|---|
Advanced users also can use regular expressions. For example, instead of writing the full names you could use 'APPLE.*', 'AM.*' and 'NM.*' names and they would work the same as the full names. The combination of .* symbols just means that the word sequence can be followed by any symbol any number of times. |
...
Go ahead and disable the "GP Target" calculated member and enable "My GP target".
To finish up the report go back to "Gauge" tab click on a measure's name that is not your target and select "Gauge limits":
Here you have to set your target as measure. In this case it would be "My GP target".
Just apply the changes and you will have your own gauge limit report ready.
If you wish you can further customise the gauges by changing colours and adding more values if you would like.
Updating "Sales person target monitor overview" with the new data
...