Pivot table row total percentages

Hello experts
I am looking to use BI publisher 11g to create a pivot table with counts and percentages in it like so:

User-------------Status----------Count----------Arrangement Status
--------------------------------------Count----------cancelled---pending-----current-------complete
Jim----------------------------------5-----------------0%----------20%----------60%----------20%
--------------------On--------------4-----------------0%----------25%----------50%----------25%
--------------------Pending--------1-----------------0%----------0%------------100%--------0%
Caroline----------------------------1-----------------0%----------100%---------0%------------0%
--------------------On--------------1-----------------0%----------100%---------0%------------0%
Micheal----------------------------5-----------------20%---------40%----------20%----------20%
--------------------On--------------4-----------------25%---------50%----------0%------------25%
--------------------Finalled---------1-----------------0%----------0%-----------100%----------0%

I can't seem to work out how to make it do percentages of the row total however.

Has anyone run into this problem before? Would appreciate some input on how you solved it.

Thanks