MicroStrategy Report grouping by two different dates -
02-20-2005
, 06:04 AM
Hello:
I need to do a MicroStrategy report like that:
Year Items by DATE-1 Items by DATE-2
--- --------------- ---------------
2005 43 30
2004 124 96
2003 112 154
..
..
..
The definition of my base Oracle table is like that:
ITEM_ID NUMBER(8),
DATE-1 DATE,
DATE-2 DATE
What attributes, facts, etc have I need and how to do that report?
Notice that I have to group items "from two different date fields of
the same Oracle table" in the same report!!!!...
Dou you know any examples in the Web?
Thanks. |