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
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