How to display data in clustered column chart - when working with date data

Do you have a Calendar table?

If you do place the date on the axis and keep only the month from the resulting  Hierarchy,

then drag the date field again but this time to the legend and keep only the year.

If no Calendar just break your date field into Month and Year columns and use those...

Place Month on the Axis, Year in the Legend and sales in the Values

Good Luck!:smileyhappy:

Hi prokurors,

As Sean suggested, I could get the chart output like below. In my test, I didn't use calendar table, just select Month from date hierarchy as Axis, and select Year from date hierarchy as legend.

Best regards,
Yuliana Gu