Calculate share in SAC on total amount for article

[maria_hjelm]

Hello!

I have a question I wonder if anyone can help me with.

In SAC I have a dashboard that calculates share of sales. Both for a dimension customer pricing group in one dashboard and article in the other.

When I click on one customer pricing group it will filter this in the article dashboard.

The share in the article dashboard is now calculated based on the sales for the article on the customer pricing group combined with the total sales for the customer pricing group.

What I want to accomplish instead is to have a share based on the sales for the article on the customer pricing group combined with total sales for the article despite of the filter of customer pricing group.

Does anyone know how to do this? We are using SAC on a live data connection based on a bex query.

Thanks!

/Maria