------------------------------------------------------ Separate question: Is there a way I can do percent of total metrics? E.g.

Product category | Revenues ($) | % of total (%) |
X                |.        3000 |             25 |
Y                |.        4500 |           37.5 |
Z                |.        1500 |           12.5 |
W                |.        1500 |           12.5 |
U                |.        1500 |           12.5 |

Assume Revenues ($) is a metric and cannot be simplified to SUM(Revenues)

There is a checkbox in mertic configuration in Analytical Designer “show in %” but it is active only if there is only a single metric in insight. You can use also MAQL expression:

SELECT Revenue($)/ (SELECT Revenue($) BY ALL OTHER)

If you add additional column (e.g. Year) and you will want to see percentage of product category for each Year and not percentage of revenue for all the years you have to use slightly different MAQL:

SELECT Revenue($)/ (SELECT Revenue($) BY ALL Product category)

Marvellous, thanks Jakub