Is it possible to create an aggregate formula that uses the grand total from a column.

I know that you can get this number in a pivot table (% of total) but that number cannot be used as basis for  an aggregate formula.

Se screenshot. I've got an grand total i Col1 (60000). Based on that I calculate a Weight. I use this Weight to calculate the Col3 values.

I know that I can achieve something like this using a Query Table, but it would still not function properly if I wanted to introduce user filters in a summary view.

Looking forward to your response.