Apptio for All

View Only

Duplicates in the editable table's dropdown list

Jump to Best Answer

Apptio Community Member posted Thu March 07, 2024 12:35 PM

In one of my "Editable Tables" I use a formula to get the values that should appear in the drop-down menu. However, I wanted to know if there is a way to put a function to remove duplicates in it.

Here is the formula:

%Gestores/!LIMIT_COLUMNS[Gestor N1]

Regards,

#ApptioforAll

Jenny Franklin posted Thu March 07, 2024 02:06 PM Best Answer

Hi @Paulo Henrique Correa Pinto, got an answer for you - per Andy...

You can group them by adding !GROUPBY[referenced column]Based on your formula, the syntax would be as such:%Gestores/!LIMIT_COLUMNS[Gestor N1]/!GROUPBY[Gestor N1].

Thank you @Andy Liang! 🙏

#ApptioforAll