How to drill date (column )into month in xcelsius
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
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