Column in straight table list all values

[jpapador]

I have a table with multiple dimensios but one is date.  Is it possible to have a column list it's values even if it is not specific to that date.  For example:

CURRENT

Date                Car               CarId            Serivce

1/23/2013         Ford                12            Oil Change

1/23/2013         Toyota             55            Brakes

1/31/2013         Ford                12              -

2/2/2013           Ford                12            Tire Rotation

2/4/2013           Toyota             55            -

2/6/2013           Toyota             55            Power Steering

What I would Like:

Date                Car               CarId            Serivce

1/23/2013         Ford                12            Oil Change, Tire Rotation

1/23/2013         Toyota             55            Power Steering, Brakes

1/31/2013         Ford                12            Oil Change, Tire Rotation

2/2/2013           Ford                12            Oil Change, Tire Rotation

2/4/2013           Toyota             55            Power Steering, Brakes

2/6/2013           Toyota             55            Power Steering, Brakes

Is this possible?

[alexandros17]

Yes, try with If in the dimension field and set your condition

[jeffmartins]

Hi jpapador,

You need to adjust your data model to get the services and dates related.

After relating the services and dates you can use the concat function to get the services separeted by comma at the same line.

Regards

[#4 · Accepted solution]

Assuming CURRENT is your data model, you can use the total key word with the concat function. Create a straight table with Date, Car, and CarId as the dimensions and use Concat(Total <Car, CarId> Service, ', ') as the expression.