Create Heatmap Table

[Stickman]

Looking to get help on creating a heat map for a weekly view for each product.

I'm not sure how I can have the week # (from 1 to 52) placed on the top row and the products down the first column.

I've attached a sample picture of what I would like it to look like.

Can someone help me construct the table please?

Thank you

[marcus_sommer]

Take a look here: The great heat chart

- Marcus

[Stickman]

Marcus, thank you for the quick reply.

When I add the Date dimension, it puts it down the column instead of across the row. Is there a fix to this? What am I doing wrong?

[marcus_sommer · Accepted solution]

You need to use as chart-type a pivot and there you could drag the column into a horizontal position - left click on the column-header and then dragging.

- Marcus

[Stickman]

Genius!