Grouping - 1 Value in 2 separate groups

[Anonymous]

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

[TeigeGao]

Hi @Anonymous ,

The value can only be set in one group.

Best Regards,

Teige

[Anonymous]

@TeigeGao 

Thanks for getting back to me, is there any other suggestions you have? this is for a drop down slicer?