I am using BO 3.1 against SAP BW .
In my report, I can create a table based on a string date field called [Query 1].[L01 Cal. year / month] with the format of "09.2012" for a value. I am able to put
this field in a crosstab and have it display the correct total for each month.
But, now, I need to remove the crosstab part and just display a total for the previous month.e.g. September 2012.
I am able to use the following formula and get the correct result.
Sum([Units] ForEach([Facility])) Where ([Query 1].[L01 Cal. year / month] ="09.2012")
But, I obviously have to hard code the month-year value.
When I try to use the field in the formula instead of hardcoding it, it returns the total for all of the months in the year..See below...
Sum([Units] ForEach([Facility])) Where ([Query 1].[L01 Cal. year / month] = Last(Query 1].[L01 Cal. year / month]))
I have attempted to use Trim,and Substr functions,and to also convert the values to an actual date value, but to no avail.
Any help with this formula would be greatly appreciated !
Thank You.