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

[gregor_dieckmann · Accepted solution]

Hi Maria,

you may try the following in the BW query

• Let A be dimension Article
• Let CPG be dimension Customer Pricing Group
• Let S be measure (key figure) Sales

The query might have A, CPG drilled-down in the rows. Create an RKF (restricted key figure) as follows:

• RKF is based on S
• Add CPG as restriction in the RKF and using the context menu mark this dimension as 'Constant Selection'

Create a formula F (% Share of Sale with const. CPG) as follows:

• F:= S / RKF * 100

This query should return the values you want.

Regards,

Gregor

[maria_hjelm · Accepted solution]

Thanks! Works perfectly!