Could you please upload sample data and create the calculated fields in QuickSight Arena and share the dashboard here . This will enable us to help you better and faster .
Please check the below article to learn how to use QuickSight Arena and share the dashboard in community .