How to create a second column from a dimension value.

[Anonymous]

Hi, I was hoping someone here would be able to help me.

I have the below data and would like the dimension data as value in one column (as the results pic), instead of 3 records.

So the first Channel in 'Channel 1', the second Channel in 'Channel 2' - this is in order by 'TV_Date'

I managed to display the first value by the below code, but need help on the following columns...

=FirstSortedValue({<TV_Date={'=aggr(min(TV_Date), FTVID)'}>}Sender, TV_Date)

Any help appreciated!

Best,

Betul

Data

Results

[sunny_talwar]

May be try this:

What would Channel 2 = ? since both 13th Str and History have exactly the same TV_Date?

[Anonymous]

Hi Sunny, Can go by alphabetical order if the TV_Date is exactly the same.

[sunny_talwar · Accepted solution]

May be this in straight table

Dimension: FTVID

Expressions

Channel 1

=FirstSortedValue(Channel, TV_Date)

Channel 2

=FirstSortedValue(Channel, ((TV_Date)* 100000 + Ord(Left(Channel, 1))), 2)

Channel 3

=FirstSortedValue(Channel, ((TV_Date)* 100000 + Ord(Left(Channel, 1))), 3)

[Anonymous]

Hi Sunny,

That works great! Thank you so much for your help.

Betul

[sunny_talwar]

Not a problem