Best Of

Hi @abarrie23, in your dataset, would there be any field values that contain operating characters, like a \ or ", in the value?

Hi @FME_Cavinder, you can use a concat function to get that name and text field. For example, if your dimension is 'OrderID', then

CONCAT ('Order #:', 'OrderID')

This can be done for as many columns of your drill-down table report as you need.

Let me know if you are after something else.

Hi @ramoshe, the Pivot table will only accept 'Measures' in the Values field. You'll likely have to forgo the multiple headers options for your table (by choosing a different Table chart type that will enable text values in the cells) and instead have those header options as filter cards next to the table in your page/dashboard (e.g. LO type = LO1, LO2 etc).