Concatenate three dimension into one with fields headers

shahfaisalq — Mon, 20 Dec 2021 21:08:46 GMT

Hi,

How can we achieve this?

The requirement is to display three dimensions as one dimension with the field headers. As shown in the down below table. Description column.

I used this script which only concatenates the values. but how we would add the headers in it with the values.

=[Area] &' - '& [ID] & ' - ' & [Year]

Please help.

thanks

Regards

Re: Concatenate three dimension into one with fields headers

lironbaram — Thu, 30 Apr 2020 17:11:24 GMT

you should use something like this

='Area- '&[Area]&', ID- '& [ID] & 'Year- ' & [Year]