OK, that worked easily, except I couldn't figure out how to use the variable for a while.
You have to refresh the query, first of all, and I saved somewhere along the way, too (though saving was not enough).
Then I didn't realize I did not have to add the variable to my query, which I kept trying to do -- but couldn't find the darn new variable.
So, the way you "drop the new variable into your report" is actually to format the table/chart and on the Pivot tab you make the change.
Looks great! Thanks, again!
OK, I wanted to do this in a different way and the method described above is not working this time.
I have a report that displays Container Name in a table. I want the container names to be different, though. Instead of Community, I want to see Space and instead of SOCIAL_GROUP I want to see Group.
I created variables for this, but no luck. Here's the report I am working on: https://bi.ondemand.com/show/1bbiAQz4aQoFRiBBqMQJwlsqVsc?fullscreen=true
Here's how you can do that:
1. Create new Variable we'll call it "Type of Container"
2. Use an "If" formula to define the replacement terms (works the same way as in Excel).
3. Drop the new Variable into the report.
4. You can then remove the Container Type Column.
I saved this change to the report you built. Let me know if you have questions.