Apptio for All

 View Only

 Editable Table Column Configuration for Unique List Values and Months

Jump to  Best Answer
  • ApptioforAll
Dawn Kassube's profile image
Dawn Kassube posted 11/18/22 04:27 PM
  1. Is there a formula in the editable table column configuration to have only unique values available for selection.  In the lookup table there are multiple occurrences of the value but in the Editable Table list I only want to see unique values.  
  2. How do you add the Months as columns in a report using an Editable Table?  Do you have to add the columns in the Editable Table?
Thank you
#ApptioforAll
Attachment  View in library
Editable Table.docx 56 KB
Rene Norskov's profile image
Rene Norskov posted 12/02/22 12:43 PM  Best Answer
@Dawn Kassube To only list unique values you could add a GROUPBY clause in the Possible Value field. Something like this: 
%Table/!GROUPBY[Column]/!LIMIT_COLUMNS[Column]​
​For the months I'm afraid you will have to add them one by one manually.
#ApptioforAll
Ben Foster's profile image
Ben Foster posted 11/22/22 10:19 AM
Hi Dawn -

1. I can't think of any way to use the Possible Values field in the editable table to pull only the unique values using a non unique list. 

One possible solution is to create a reference backing table for the editable table that contains this information in the format you want it in (a pipeline step to remove duplicates). I would then use the following formula in the "Possible Values" field of the editable table column: %MyNewTable/!LIMIT_COLUMNS[MyUniqueColumn]

2. I think I need more background information on this one. But I will assume the goal is for users to enter a forecast volume for each month. If that is the case, I would create a column for each month in the editable table.
#ApptioforAll

Related Content