Pivot Table Query

I have the following pivot table query



I am using a date field in the 'column'

I have two row headings 'Area' and 'Team'

I have a 'score' field as my data field which i sum'd

I would like to have under each date a percentage. When i am viewing the data by Area i would like to see the sum of scroe (which i can already see) as well as the percentage of scrore / Area for each date.

When i double click area to reveal the scroes for the teams i would like to see the sum of scroe (which i can already see) as well as the percentage of scrore / Team for each date.


Is this possible?

dont worry got it sorted now