Hi. I have a table that has only dimensions & no Expressions.
Here are the first few rows .
I want to do a merge & center like we would do in excel in a similar situation.
How can this be implemented using a table box?
No, that cannot be implemented using a table box. You need an expression for that and therefore a chart object like a straight table or pivot table with Task as dimension and as expression concat(distinct [Sub Task], chr(10)).
A tablebox could only show data how they are - you will need a table-chart and could use a calculated dimension or an expression like this:
concat(distinct [Sub Task], chr(10))
This does not work.
May be like attached sample.
Edit: If you are interested in values without line separator, have a look at the second chart.
Retrieving data ...