Data/Table Manipulation & Expression

[alwayslearning]

Hi

I upload some data like the following:

Project ID     Checkpoint   Delivery Date

001               1                    01/04/2017

001               2                    01/06/2017

001               3                    01/10/2017

002               1                    01/05/2017

002               2                    01/06/2017

002               3                    01/07/2017

I also have a master calendar

I want to display a table like the below:

Project ID

Checkpoint

Jan-17

Feb-17

Mar-17

Apr-17

May-17

Jun-17

Jul-17

Aug-17

Sep-17

Oct-17

Nov-17

001

1

01/04/2017

001

2

01/06/2017

001

3

01/10/2017

002

1

01/05/2017

002

2

01/06/2017

002

3

01/07/2017

[vinieme12 · Accepted solution]

See Attached APP

[vinieme12]

Just Drag the YearMonth field from your Master Calendar, over your Expression, you will see blue reference lines that denote the position where the column will be dropped

[ahaahaaha]

You can still remove the null values so that do not show the bottom line.

[alwayslearning]

This work for me.

Thanks.

[alwayslearning]

Just a follow up.

I want to highlight the values where the checkpoint date appears by colouring the cell.

[vinieme12]

in background expression try

=if(not isnull(DeliveryDate),rgb(0,176,252))

[vinieme12]

yes, i just created it for reference

[alwayslearning]

Thanks again.

Just remembered to place that expression in the 'background colour' in the expression section. I was placing it across the whole table via custom format cell.