I would like to make a straighttabel with three dimension and one expression.
Expression = NetBilling
dimension1 = MTD actual
dimension 2 = YTD actual
dimension 3 = YTD forecast
I am using a listbox to select the period (field name = JC.MonthDateShippedDue). Period formatting is 2010-01, 2010-02, 2010-03, 2010-04, 2010-05 etc.....................................
I am seeking to get the following report. For example, when I select period 2010-05 on the list-box. The dimension fields should show the following results:
Dimension1= only NetBilling for period 2010-05
Dimension2 = NetBilling for the Periods 2010-01,2010-02,2010-03,2010-04 and 2010-05
Dimension3= NetBilling for the periods 2010-06, 2010-07, 2010-08, 2010-09, 2010-10, 2010-11 and 2010-12
An nother complexity is that i have periods that are 2009 and older and 2011.
Hope someone can help me with this challenge [:)],
