A rather simple table issue!

Mon, 28 Jan 2013 16:18:12 GMT

Hi I have data that looks like this:

I would like to present it like this:

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

Re: A rather simple table issue!

swuehl — Mon, 28 Jan 2013 16:26:15 GMT

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

Please find attached.

Mon, 28 Jan 2013 16:27:13 GMT

Hi Tor,

See attach file. Is that what you want ?

Regards,

Nicolas

Tue, 29 Jan 2013 08:25:33 GMT

Thanks a lot bud!