This has been reported by other community members as well. I recreated this in my environment and got the same issue. At the moment, the only substitute I was able to find is if you use a Table visual instead of a Pivot Table, but if this is not an option, I would highly recommend opening a support ticket: Case management - AWS Support.
Here are the other community posts where users raised the same behavior: