Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. I have a table that has only dimensions & no Expressions.
Here are the first few rows .
Task | Sub Task |
---|---|
Task 1 | A |
Task 1 | B |
Task 2 | C |
Task 2 | D |
Task 2 | E |
I want to do a merge & center like we would do in excel in a similar situation.
Task | Sub Task |
---|---|
Task 1 | A B |
Task 2 | C D E |
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))
- Marcus
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.