GG
Hi,
I have a query that evaluates which processes are assigned on the different levels, starting from the process map on L1. Is there any way that, for example, the name of the L2 process is displayed in each row/cell instead of in a connected cell? Here in the excerpt in the lines B4-B15 should always be the same name of the process.
Best regards,
Greta
No and yes. The tree structure of the result is necessarily reflected in the structure of the combined cells. You could add another step, after your column 3, which is the same as the step from column 2 to 3 only backwards. But assuming that column 3 is not the last column this would also be awkward to handle and make your column 3 having combined cells.
Hi Greta,
I read your question as follows: you have a table in which column 1 states the superior model name. It is only shown once although you have multiple sub-processes assigned. To make you reporting life easier, you now want "your model name" appear three times (in each cell for each sub-process).
| your model name | abc |
| def | |
| ghi | |
| your second model name | 134 |
I hope that this is about right...
What you need to do, in order to make it look like this (see below)
| your model name | abc |
| your model name | def |
| your model name | ghi |
| your second model name | 134 |
is to click in the query object (in my example "role") and click space on your keeboard. Then the "edit item cell properties" shows up and you can untick "merge results".
Hope this helps :)
