Are you looking to do a calc something like this:
IF [Measure Names] = "Sales" then 1
ELSEIF [Measure Names] = "Profits" then 2
We simply don't have that.
There are ideas in the IDEAS forum asking for stuff like that. Here's one of them:
But consider this. A calc is attached to a row, not to a field. If you were to do "View Data", what would you expect to see in that calc?
It would require a likely change in the underlying architecture, I presume.
All the same, I wish we did have this. I could create formatting prefixes and suffixes such that I can prepend a dollar sign to a Sales value, and append a percent sign to a ratio, all within the MeasureNames/MeasureValues construct.
Thank you Joe Oppelt for your reply, I am not looking for "Measure Names" kind of option for Dimensions so that I can use it as filter and Select put all the dimensions in the view and give user option to pick which columns they want to see (Here users don't want to self Service where they can and remove dimensions by themselves).
I'm just not understanding what you need.
Hack up an example in Superstore. Create a sheet, and then tell me what you would like the user to be able to do.