1 of 1 people found this helpful
I can think of a couple ways to do this, but it's hard to say which one would be the best/fastest for you without looking at a packaged workbook. Assuming you already have a Term field that has values like "Winter 2015," my guess would be to first create two calculated fields: Term Name and Term Year.
LEFT([Term], FIND([Term], " ")-1)
Then I would right click Term and select Create>Parameter and click OK, then show the parameter control. Finally, I would create a Filter calculated field that says:
IF [Term Name]=LEFT([Term Parameter], FIND([Term Parameter], " ")-1)
AND (INT([Term Year])=INT(RIGHT([Term Parameter], 4)) OR INT([Term Year])=INT(RIGHT([Term Parameter], 4))-1)
Finally, I would filter on only the "YES" values in the Filter calculated field.
Thank you so much for your response, I tried your suggested formula but it seems that it is not solving the issue, I have attache sample workbook for your review. If you need any clarification kindly let me know.
Book3.twbx 288.4 KB
Please find the attached solution and look for the 3 calculated fields: 1) Term Name 2) Term Year 3) Comp.
It borrows from what Benjamin had alluded to in his reply. Since he had replied before you posted the workbook I have done some modifications to reflect the actual data.
Book3.twbx 301.5 KB
Hello P N
Thank you so much for solution. It really solved my issue. Thank you