View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rodchar rodchar is offline
external usenet poster
 
Posts: 80
Default 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