How to show month and year in a chart?

[Anonymous]

Hi,

I have a chart that shows accumulated values, but it only shows the year value, as the image bellow:

More than the year, I'd like to show the month as well, as this other chart:

How can I do that?

[Greg_Deckler]

@Anonymous Well, you can create a new column that includes both month and year. Or you can put both Year and Month in the field well for the Axis and then use the forked arrow drill down.

[Anonymous]

When I drill down, thats what I got

I don't want to create another column so my file don't get to heavy. This other chart I've created with tha same tables, but it worked back there, and now it doesn't, I don't know why

[Anonymous]

Found out! Just right click on the date option, and changed from "hierarchy" to "date". Thanks!