determine in datasource or pivot table
 

hey all,

i have a pivot table that gets data from sql like the following:

NumberInInventory, NumberSold
10,7

I'd like to add a calculated column called %Sold so the table will look like:

10, 7, 70%

Is this possible with the pivot table that has a database as a datasource?

thanks,
rodchar