Grouping - 1 Value in 2 separate groups

Hi, 

I have a status colum with the following 2 status

• Active
• Completed

For the user experience the requrement is to have 2 groups 

1. Work in Progress
2. Total

The "Work in Progress" group should contail only the Active status. The "Total" group should contain both the Active and the Completed status. My issue is that a status can only appear in on group at a time. 

Any help is appriciated

Thanks 

Rob