Calculate Shares for a dimension (e.g. Supplier) AND a time period

[f1234567]

Hello experts,
I have a question which looked easy in the beginning. However, I didn't get it right.

I have following Dimensions :

Product, Distr, Producer, Period
(Period is a Group out of a calendar and can be changed from YYYY_MM to Quarter, to year)

The Pivot Table:

The calculation formula here is:

Sum({<Distr= >} [Daten])  

But how would I get this result?

As soon as I add "Total" to the formula, it would calculate the full period selected as total and not total month by month (or quarter to quarter or year to year if the group "Period" is clicked).
I am sure there is a set analysis formula to be used but I couldn't find any to give me above solution.

Many thanks for any hint!
Best
Frank

[edwin · Accepted solution]

see attached if this is what you were looking for:

[f1234567]

Very cool script and solution! Thank you!