I am very new to discoverer and trying to figure out drilling option. I have a date item, which is not grouped into months/ quarters. They are just captured as individual dates : Jan 4 2012, Jan 7 2012 and so on. Is there a way to group these dates into months and display them on the crosstab. How can I achieve that?
Any help will be greatly appreciated.
PS: We use Discoverer 10g (10.1.2.48.18)