Splitting the column into different columns

[Nithesh UC]

Hi All,

I have a challenging scenario which is mentioned in the document attached.

Any kind of help is much appreciated.

Thanks,
uC

[cognostechie]

This is possible using MDX but the source has to be a Cube or DMR.

You can also do this by using a Crosstab instead of a List if your source is relational package. Use a Crosstab, put the time in rows, All and Trucks in Columns and nest the data item representing ODs under All and Trucks. You can also try the other way around. Put OD in the column and nest All and Trucks under the OD.