Hi David:
Insert a calculated field into the pivot table (the little icon that looks like a calculator). You'll get the commands and options window pop up on the calculation table. At the bottom there is a list of fields you can insert reference to.
Select Work (Total) and click on Insert Reference To. Type a forward slash, then insert a reference to Availability (Total) and your calculation will look like this: [Measures].[Work]/[Measures].[Availability]. Then click on the change button at the bottom and your calculation will become visable in the table. This gives you the amount of work as a percentage of the resources availability. You can play around with the fields in the calculation to get what you are looking for. Once you've inserted a caluclated field, it is added to the list of fields you can select from.
Caution: If you get a calculation where you might divide by 0 then you can use a conditional iif (test,true,false) to test for zero, but this only works when you have simple groups of infomation, the more detail, the less likely it is to work and you just end up with blanks, or you loose some of the filtering that you have selected.
Next click on the captions tab and change the caption New Total (1) to what you want it to read. Don't pick the name of an existing field otherwise it will only format the field like the exisiting field.
Then click on the format tab and change the number to %. There are lots of things you can play around with here to change the look except conditional formatting.
I hope this helps!
