Creating columns filtering on another

[RichieJW]

Hi,

I have tried a few of the other tips on here to help me with this, however I cannot get them to work, and I'm sure it should be so simple!

I have 2 columns of data: -

'BaselineNumber' - which has numbers ranging from 0-10 inclusive

'ProjectBaselineFinishDate' - which is a date (dd/mm/yy)

I need to create 11 columns of data showing the 'ProjectBaselineFinishDate' for each 'Baseline Number'. As I need to do this in the same table, I'm struggling to use the visual filters.

So, my output should be 11 columns, with: -

'ProjectBaselineFinishDate' - only showing 'BaselineNumber' 0, displayed as a date

'ProjectBaselineFinishDate' - only showing 'BaselineNumber' 1, displayed as a date

'ProjectBaselineFinishDate' - only showing 'BaselineNumber' 2, displayed as a date

etc., all the way up to 10 and all able to be displayed in the same table.

Many thanks,

Rich

[amitchandak · Accepted solution]

@RichieJW , You have two to create 10 columns like

B0 = if([BaselineNumber] =0 ,[ProjectBaselineFinishDate], blank())

B1 = if([BaselineNumber] =1 ,[ProjectBaselineFinishDate], blank())

Or in visual you can use Matrix

[RichieJW]

Thanks @amitchandak , I'll give this a go and will accept as solution if all good.

Appreciate your time.

Rich