How to link configuration name to dimension?

As you know, Excel allows you to create advanced Configuration tables. The undoubted advantage of such a solution is the possibility of using formulas.

excel

For example, I have a collar, where I want to display a combined column with outer and inner dimension as configuration name.

To do this, you need to glue two columns into a name using a formula: CONCATENATE(text1;[text2];…) or characters & and “. remember, that even a space has to be in quotation marks.

Example below:

excel

Leave a Reply

Your email address will not be published.