We have a DSO with several date characteristics. Example - Open Date, Recived Date, Actual Delivered date etc.
There is a requirement to run a summary report by month for these dates.
Example - by Month on Delivery Date would be
Sales Value1 05/2006
Sales Value2 06/2006
My question - with out having to create a Cube and rolling up data - is there a way to report of a DSO but show the corresponding date as CalMonth/year format.
I am aware of creating a variable of restricting dates by period but not sure if I can actually display any specific date as MM/YYYY.