Filter Selection Not To Affect Rows

[Whales]

I have a small data that I wish to compute some other measures:

Year	Month	Continent	Country	GDP
1999	6	Asia	China	5000
1999	6	Asia	Japan	3000
2000	7	Asia	Japan	8000
2000	8	Africa	South Africa	5000

I wish to compute the Continental GDP and Percentage GDP. I computed using the following:

Continental GDP = SUM(TOTAL <Year, Month, Continent> Sales)

Percentage GDP = SUM(TOTAL <Year, Month, Continent> Sales)/SUM(TOTAL <Continent> Sales)

I got the following: 

Continental GDP	Percentage GDP
16000	50.0%
16000	50.0%
16000	50.0%
5000	100.0%

However, I want a situation whereby if I filter on the Month and Year, that the filter will still not affect the rows. I want an output like this after selecting Year 1999 and Month 6:

Year	Month	Continent	Country	GDP	Continental GDP	Percentage GDP
1999	6	Asia	China	5000	16000	50.0%

Is there a way I can adjust my formular(s) to achieve this above output?

Thank you.

[vinieme12 · Accepted solution]

As below, changes highlighted

=Sum( Aggr (
sum( {< Year=,Month=>} TOTAL <Year,Month,Continent> GDP)
/
sum( {< Year=,Month=>} TOTAL <Continent> GDP)
,Year,Month,Continent,Country))

[Whales]

Thank you. This works pretty well!