Pivot Table show 100% in totals by columns

[Sebastian_Dec]

Hi, please help.

I need to show in pivot table 100% in totals by columns (shops).
Unfortunately, I have +50 stores and I'd rather not make a separate expression for each store + the boss wants all stores to be seen at once.

Dimension/Row: Shop
Dimension/Bar: Group
Measures:  sum(sales)/sum(total sales)

I currently have:

And I need example:

[Or · Accepted solution]

Sum(Sales) / Sum(Total <Shop> Sales), perhaps?

[Sebastian_Dec]

You're a genius, thanks!