I have a report requirement to have selectable measures to display in a report. For example we have a list of 4 to 5 columns (dimensional data) and 5 measures all dollar values.
The end user requests to have the capability to select unit or cost values instead of the sales dollar values. Can I select dynamically, from a list of available measures?
I'd like to know if it's possible to dynamically read all relevant measures from the package at hand? I don't want to hard code this in the report, it will be a maintenance nightmare.