Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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