Re-reading my question, you're right... that's not answerable as stated.  I'm doing this in PowerBI / DAX, so I have a simple star schema with Customers and Sales ... 

Henric,
Nice post for a rookie. Welcome to SSC.  Here's a script to create the table and populate it with some data... I added a few extra records to make...

LOL. I just did that yesterday... except it was above my head.

Maybe use a Matrix? hard to say without more details or a dummy dataset.

...and post the CREATE TABLE script for the 'PersonalProfiles' table... just want to make sure that you've defined the columns properly. Using the wrong datatype could cause unexpected results.

One way to do this is to use a Calendar table, then you can filter for Month/Year.

Otherwise, you'd have to use something like:

WHERE [EventDate] >= '01-Jan-2018'...

you never check the destination table for existing records. Why not?

This should give you a start (although you might need a Calendar table to join to so you can PARTITION wherever you want.)
https://blog.bertwagner.com/heres-a-quick-way-to-generate-a-running-total-in-sql-server-f5654d310030

You'd just wrap this part in the INSERT statement:
SELECT *
FROM Ranked
WHERE Ranked.Rnk < 4
ORDER BY Ranked.StoreNo,
 Ranked.Rnk DESC

(well, you'd have to expand the *...)

One way of doing this is to wrap your query in a TOP predicate --- I'm using AdventureWorks2014 (because being able to test my answers hopefully keeps me from making...

Just gonna throw this out there...
What if you created a few variables in your report and grabbed the population size from somewhere? Then you can just divide by that?...

Maybe it's me, but I think the table design they gave you (if accurate) is horrible. Subjects are facts/information, and don't really belong in column names. Would be a lot...