Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Creating columns filtering on another

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

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , 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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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

      Appreciate your time.

      Rich