How to dynamic market share in a table v dashboard based on filtered values?

Dear community,

I would like to ask whether it is possible to show % share in dashboards in a table view. I understand that I can create a metric that will show a market share for predefined group. But in my case there is no predefined group. Instead market share should be calculated based on SUM of all rows in the table.

Thank you