How to merge two columns into one column

Hi,

From below table, I’d like to display DevTest and DevTest automation in one column as DevTest. How can I do it?

Hi @Tuan_Nguyen

Welcome to the eazyBI Community! :wave:

If you want to merge both highlighted columns, you can define a new calculated member in “Found By” dimension with the formula below.
You can learn more about defining calculated members here - Calculated members in other dimensions
However, I suggest using the autocomplete functionality when using the formula I pasted, to make sure the syntax is written correctly. Give the name to the member (it cannot be the same name you already have for the members - "Dev Test or “Dev Test Automation”. It should be unique - for example - Dev Test Total). Once you have created the member, you can select it in the report. It may be that the other members you have in the report disappear, in such case, you can add the rest of the members by “search and bookmark” in the “Found By” dimension and then select each individual member in the report along with the calculated member you just created
You can see an example how to use search and bookmark here - Bookmark a Release member

Aggregate(
  {[Found By].[DevTest],
  [Found By].[DevTest Automation]}
)

Best wishes,
Elita from support@eazybi.com