Calculate ratio with text values

[klikgevoel]

Hi all, I've got a question regarding calculating percentages over textual data. Lets take the sample data given below (fake_data_speerpnt.xlsx). 

I want to determine the ratio of text occuring for each location at a certain year, preferably also aligned with the name. As an example see the image. 

Dataset sampleRatio calculation

Using Count(total <Location> Agreement1) gives me the output based on location selection. However, when I want to determine the ratio, so the full expression will be Count(total <Location> Agreement1) / Count(total Agreement1). The result however does not return the ratio.

The outcome should be presented in a pivot table.