Spread the values in a dimension

[mattiasthalen]

Hi,

I have a table chart like this:

TRX_ID	LPN_TYPE	LPN_NAME
123	Content	ABC
123	Transfer	DEF

In the front-end (not in the script) I wish to create a table chart that will look like this:

TRX_ID	Content	Transfer
123	ABC	DEF

I've tried doing calculated dimensions, ie:

=IF([LPN_TYPE] = 'Content', [LPN_NAME])

But this still leave me with two lines, albeit, the line for the lpn_type 'Transfer' has this column set to null.

Any help is much appreciated!

[seanbruton]

Hi There,

You are on the right track. The dimension field remove the tick box include null values.
Then your first measure is =IF([LPN_TYPE] = 'Content', [LPN_NAME])
Then your first measure is =IF([LPN_TYPE] = 'Transfer', [LPN_NAME])
Also on the measures change the labels to the new titles.

Good Luck!

[sunny_talwar]

Why don't you create a pivot table where LPN_TYPE is your pivoted dimension and LPN_NAME is your expression?

[OmarBenSalem]

Create a pivot table:

as line:

TRX_ID

as Column : LPN_TYPE

as a measure: concat(LPN_NAME,', ')

result

[mattiasthalen]

Because I need it to stay as a dimension and not a measure.

[sunny_talwar]

LP_NAME needs to stay as dimension you mean?

[seanbruton]

If they all need to be dimensions use my same process and use a table and only create dimensions. Untick remove null values.