% remaining spread in Resource Assignments

It feels as though I have learnt 2 years of planning skills in 2 days reading through these forums, so I thought I would try my luck with another query.

In resource assignments I am trying to ascertain % complete instead of units using resource assignments. for example I currently have a bulk ew material resource, the resource assignment then allows me to see how many units (bcm) will be expended over time however I want to see % of remaining. I am currently using excel to do the spreading. I am expecting something like the top table, instead of the qtys on the bottom. Mind you it is not hard to do in excel but would be nice to use P6 instead

 

Activity	30-Apr-12	7-May-12	14-May-12	21-May-12	28-May-12	4-Jun-12	11-Jun-12	18-Jun-12	25-Jun-12	2-Jul-12	9-Jul-12
GLNG 651 (Day/Night)	1.95%	1.91%	1.82%	2.53%	2.53%	1.66%	1.89%	1.98%	1.55%	1.56%	1.38%
Activity	30-Apr-12	7-May-12	14-May-12	21-May-12	28-May-12	4-Jun-12	11-Jun-12	18-Jun-12	25-Jun-12	2-Jul-12	9-Jul-12
GLNG 651 (Day/Night)	28800	36000	33300	43200	47634	30600	36000	43200	43200	43200	43200