Hello @OBUILE , welcome to the Quicksight community!
Have you looked into using a Lambda like the solution in this post suggest?: