I have a list of transactions of a specifc type (raw data sheet). Each row of data is assigned to a specific Area, Location, and Work Group.

I want to find out what percentage of the total volume of transactions this chunk of transactional data represents. I'd like to display these results in a pivot table so I can show a percentage breakdown for Area > Location > then Workgroup.

My problem is finding out the function of the pivot table that allows me to divide a COUNT (of the transactional data) by a constant (total volume of transactions). When I do a calculated field, I keep ending up with something like 26,000% when the real answer should be < 1%.

Any suggestions on how to accomplish this? When I enter the formula for the calculated field I'm putting "=COUNT('CustomerID')/'Transaction Volume'". Does this seem wrong? Anything helps.