Percentages in a pivot table?

A

Atif

Hi;

You can perform any calculation based on available fields in query of your
pivot table,I am calculating percentage like this
in design view go to last available column:

Filed = Percentage: ([Signed]/[Issued])
Total = Select "Expression" from the list
right click any where in the same column, Select "Properties"
Select "Percentage" from the list

Atif
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top