Total RangeSum Issue

[michaelneck]

Hi All,

I am having an issue with trying to get a Total Rangesum to work correctly. The below rangesum (column 4) is working as it should, but what I want to do in (column 5) is to take the sum (column4) of all the Tiers for the month and then in (column 6) to see the proportion of each tier. Please see below the table so far and then example tables of what the two other columns should look like and how they should calculate. Any help would be appreciated..

[michaelneck]

Also Just to be clear I am using Qlikview 12 for this..