I have report that has 5 columns , Product Id Product Decription, Quantity & dates for 3 months now I want to slice & dice it such a way that months go as column header & Quantity is filled below it
Eg: Table should look like this
Date1 Date2 Date3
Id Descr Qty Qty Qty
Because Date1, Date2, Date3 are fixed to one particular value
when I try slice & dice this is what I get
I guess I have figured a solution though I dont know how to Implement it
actually the three objects Date1, date2, date3 have just one value in them so if I can manage to create another Object that has these three values then I can put this new obj in slice & dice , Can any one explain how to add three calculated values inside one Obj in my case it will
read system date & create 3 values previous month , 2 months back date , 3months back date
eg system date is 07/16/2004
create a Obj having values 06/01/2004,05/01/2004,04/01/2004
I know how to create the dates but dont know how to create them in single Obj right now I have created 3 different Obj fo 3 dates
(BOB member since 2002-06-20)