Problem with calculation of Totals

[francisvandergr]

I have a problem with a formula. I have a datamodel of individual records with the following information :

Period, Country, Turnover and GM

I have more records from 1 country in a period. For example : Netherlands Period 1.

I want to calculate with the Totals: so in period 1 i want to see for the netherlands :

75 / 130 = 0,576923077

and in period 2 i want to see for the netherlands :

500 / 1100= 0,454545455

And an important thing i don't want the period in my dimension.

I have enclosed the example

[#2 · Accepted solution]

Hi Francis,

a quick shot using SET ANALYSIS (fixed values).

A better solution will be to have it dynamic of course.

Good luck!

Rainer

[francisvandergr]

Thank you for your solution !!!