Hi
I am working with a dataset consisting of yearly sales figures for different suppliers.
I want to look at marked shares per supplier for each year.
When I Use pivot table I can right-click on the sales numbers and choose "show as % of column sum" and get the numbers i want.
The problem occurs when I use a slicer to look at one or a couple of the companies. The marked share then changes and does no longer show the market share, but the % of sales in that selected group.
How can I fix this problem?
The attached excel-file is just an example, but my problem is illustrated under the "pivot" sheet.
Bookmarks