Hi All,

I am wanting to make a report in Webfocus (7.7) that has a displays part of certain rows and all of other rows, like below.



This is just a simple example, but I need to show retention numbers for the university I work at. We have the code to make the spreadsheets, but currently, have to buy hand delete the junk (i.e. 5 years after 2014-15 is 2019-20 and hasn't happened yet) in excel.

I honestly have no idea what to do in webfocus and thought I'd see if someone had done something similar before.

Thanks.

This message has been edited. Last edited by: <Kathryn Henning>,

Not sure about anyone else, but I don't get the picture.

The image tag in the original post was set up incorrectly. I don't really understand the question. It seems like a filter would exclude the unwanted rows, something like this untested example:

-SET &CURR_FY = &YY | ' - ' | (&YY - 1);

WHERE FY_COLUMN LE '&CURR_FY'