Date showing through X axis

[#1]

Hi team I have to show my date like below

1    2     3      4     5     6     7     8     9     10     11     12

                                 2015

Where 1,2,3,4,......,12 is the Month and 2015 is Year. My date in YYYYMM format.

Is it possible?

Regards

Anup

[Anonymous]

create a list box as Year(date#(Datefield,'YYYYMM'))

Create another for Month

num(month((date#(Datefield,'YYYYMM')))

hope this helps, upload sample app

[#3]

Thanks Bhagirath for your reply, I want use this time dimenssion into a object as a dimenssion.

[Anonymous]

No Problem create a Calculated dimension as

Year(date#(Datefield,'YYYYMM'))

and another as num(month((date#(Datefield,'YYYYMM')))

[amit_saini]

Hi,

See the attachment.

Thanks,

AS

[#6]

Bhagirath it's not working.

[#7]

Thanks amit. But I want a calculated dimension where Month and Year will be shown like my post. Actually I want to show my charts X axis like ----

1    2     3      4     5     6     7     8     9     10     11     12

                                 2015

[buzzy996]

very much possible,

if ur having month & year as 2 dimensions,pls add those 2 dimensions in ur dimension tab & put ur expression expression tab.

tht will show automatically into ur chart accordingly ur needs.

[Anonymous]

can you share sample app

[#10]

Actually Shiva, I have to show month wise company sale. So Company is another dimension in my chart if I add Month & Year as a different dimension then it will not work. Thanks for your reply.