Trended Worker, but for Tenure at Termination

HI All.

Wonder if someone can help me out please? I have a bit of a half formed idea and I was wondering if it is possible.

I currently use a trended worker report (matrix) with a bit of supervisory org, gender, then counts of opening headcount, ending headcount, hires in period, voluntary terminations etc.

I wondered if it was possible to create a calculated field which has tenure at termination < 1 year and > 1 year so I can calculate attrition with under/over 1 years service?

I would expect it to look like when I add Gender to the report, so I can see heads, terms, hires by gender, but see heads and terms by LOS at Term >1 year and LOS and Term >=1 Year.

or similar!

Thanks all, I always appreciate your genius.