Skip to Content
0
Former Member
May 23, 2011 at 06:11 PM

How to drill date (column )into month in xcelsius

37 Views

Hi,

I am fresher to Xcelsius. I need to know how to drill the date column into month, then further drilling down month to day.

I have 2 columns

Date Revenue

1/1/2010 452553

2/2/2011 97992

3/5/2011 23526

4/3/2011 63563

If i click " 1/1/2011" date column, i need to see the corresponding month data in seperate chart( i need to get the detailed data).

I need to know how the datas should be arranged in excel.

Thanks in Advance

Regards,

Abirami