Thanks @DylanM, this is a brilliant approach. @cmot, we hope this solution works for you. Let us know if this is resolved. And if it is, please help the community by marking the above answer as a “Solution.” (click the check box under the reply)
In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and post it here. (Details on using Arena can be found here - QuickSight Arena