Use Matrix Share mode
This mode is only available when a matrix is active; it is not available in Summary view.
Matrix Share mode takes your existing matrix and displays the data as a percentage, with each row summing to 100 per cent. It is a useful tool where ratios are important, for example, if you want to compare the ratio of Product X to Product Y.
The following example uses Matrix Share mode to identify which customers have bought downlights but not transformers, both this year and last year. Suppose you know that typically one transformer is required to run two downlights. That is, a 33.3% / 66.6% split, based on quantity. You want to identify the customers that are outside that ratio, in other words, which customers are buying fewer transformers than expected.
Start with an existing a matrix (this example continues with the example in the Compare data with Matrix mode page).
Select Measures > Quantity and remove the Local Value measure.
Select Mode > Matrix Share. The grid updates to display the quantity data rather than the local values, and the percentage split for each customer, for each item (the columns sum to 100%).
(Optional) Go back to your regular matrix: click Mode > Matrix.
