1 Reply Latest reply: Mar 19, 2012 6:35 AM by Celambarasan Adhimulam RSS

    Using Month as a Value

    Byron Van Wyk

      Hi Guys,

       

      I am sure this is a pretty easy question but for the life of me I can't get this right. I have an inline table with Period (October, November, December etc) and a corresponding field with the values (1, 2, 3 etc). I now have a Pivot chart with a 2 dimensions, 1 being the vertical and Period being the horizontal. So running horizontally I have (October, November, December etc).

       

      I have an input box where a user would select a month like February. If this month is selected any period before this is excluded from the dimension. So for example

       

      If(Period<=vCurrentMonth,Period)

       

      Now i assumed because of my PeriodValue in my Inline Period Table it would correctly exclude all previous Periods, but instead its not. How would I get this right. Hope my explaination makes sense. I have read up on the dual function, but this, or the way i'm doing it is not correcting the problem

       

      Thanking you smart folks in advance

       

       

      Cheers,

      Byron