Using Month as a Value

[#1]

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

[CELAMBARASAN]

Hi,

Have you created month field as dual field.

     Example

     Load

          Dual(MonthString,MonthNum) as Month

     Inline

     [MonthString,MonthNum

     Jan,1

     Feb,2

     Mar,3

     ............];

Celambarasan