A rather simple table issue!

[#1]

Hi I have data that looks like this:

type	checkpoint	year_week
Actual	A	11w47
Actual	B	12w04
Actual	C	12w36
Actual	D	13w04
Actual	E	13w31
Actual	FD	13w10
Baseline	A	11w45
Baseline	B	11w51
Baseline	C	12w26
Baseline	D	13w04
Baseline	E	13w31
Baseline	FD	13w10
Checkpoint closed	A
Checkpoint closed	B
Checkpoint closed	C
Checkpoint closed	E
Checkpoint closed	FD

I would like to present it like this:

	A	B	C	D	E	FD
Actual	11w47	12w04	12w36	13w04	13w31	13w10
Baseline	11w45	11w51	12w26	13w04	13w31	13w10
Checkpoint closed

I have tried to set it up as a table with “type” as dimension and with the expression :

if(Sum(checkpoint='A'),year_week)

But it doesn’t work, please help me out! Please see attachment!

Thanks for the help!

Tor Lidnström

[swuehl · Accepted solution]

Try a pivot table with your two dimensions type and checkpoint, checkpoint pivoted to the top.

Please find attached.

[#3]

Hi Tor,

See attach file. Is that what you want ?

Regards,

Nicolas

[#4]

Thanks a lot bud!