STUMPER: Pre-solved Q&A to sharpen your TBM and Apptio skills.

Solution posted in 7 days if nobody submits a correct answer.

See title for rating: [+] Easy   [++] Moderate   [+++] Challenging

I have a report with an editable table that is backed by a dataset called Projects Mapping, and I want to edit the IT Tower and IT Sub-Tower columns. When I edit the Tower and Sub-Tower column I don't want to type in the name of the Tower/Sub-Tower. Instead I want a dropdown list of valid values to select from. How can I add a dropdown list of valid values?

This is achieved by using the <> function in the Valid Values selection in the table.

1. Go to the Data Tab

2. Select your dataset

3. Select the IT Tower Field

4. Select the Possible Values Field

5. You will then enter a formula that references the table and field you want. For example

%IT Resource Tower Master Data/!LIMIT_COLUMNS[IT Tower]

Now when you got to your report the field will be limited to values from IT Tower.

TO see the help for this replace your instance name below

https://<<instance name>>.apptio.com/biit/webhelp/studio/r11.8.0.4.93369c315c38.26651/index.html#../Subsystems/Reporting/Content/edi…

Thanks @Craig Morrill for adding the link to help on this topic. It is very helpful.