Using the Concat() function to display a string of field values as a dimension

A line-level table is normally the most granular data in a data model. For example, consider an Order Line table. The orders for each customer are stored one row per product line, and we have corresponding costs for each product on each line. When we generate a table report for such data, we will have a separate line for each product, which, in itself, is not wrong. Recently, however, a customer asked me to initiate an export for the Table report in such a way that all the products for a particular order are contained in a single cell, and the sales column should show the aggregated figure for all the products under OrderID. To tackle this requirement, I created a calculated dimension using the Concat function. The process is explained in the following recipe.

...