I have a report that displays the inventory quantity now I need
to generate a report at every month end that displays the quantity Vs Date
in this I need to check the system date & from that calculate the dates on 1st of last three months eg report run on 08/02/2004 should display
Qty on 07/01, 06/01, 05/01, & I need to slice & dice it so that in
column header the date is displayed & below it the corresponding qty
so what I did was I created 3 objects in universe that read the
system date & generate the 1st of previous three months I call these
3 Obj as LastMonth TwoMonthBack & ThreeMonthBack now in
slice & dice I can only slice either of this Objects with Qty how do
I do all three
rockstart (BOB member since 2004-05-14)