Hi @July – based on what I can see, you may need a combination of calculation and aggregation to accomplish this in a table.
I would start by looking at this blog.
Then also, review this community forum.
If you still need further assistance, consider creating a sample dashboard with a sample dataset in Arena that illustrates your problem. Post it in a new thread for better visibility. You can find detailed instructions on how to useQuickSight Arena.
Thanks,
Alex