I have data which consists of a job number and an operation sequence. The table lists vertically job number, op number
IE
123456 10 operation1
123456 20 operation2
123456 30 operation3
I would like to display it as
123456 10-operation1 20-operation2 30-operation3
How might I do this? I attempted a cross tab but it just listed the job number multiple times with the operations displaying in all cells
…10… 20… 30
123456 10-operation1 20-operation2 30-operation3
123456 10-operation1 20-operation2 30-operation3
123456 10-operation1 20-operation2 30-operation3
I think I can get close. First I made a variable with a formula combining the Operation Number and Operation Description…
Operation Number Description=[Operation Number] + “-” + [Operation Description]
And since cross tab seem to want measures in the body of the table I made a measure of the max of the Operation Number Description…
Max Operation Number Description=Max([Operation Number Description])
I added a bit to your sample data…
Here is what my cross tab looks like with Job ID as the row header, Operation Number Description as the column header, and Max Operation Number Description in the table body.
You can then either hide the column header row (Right-click, Hide, Hide row…) or uncheck “Top header” in the Format Table properties.
This does leave gaps if a Job ID is missing an Operation Number that another Job ID has. Hopefully, that is not an issue for you. If it is, perhaps you can build on this foundation.
1 Like
Thank you. This was exactly what I needed