CODEWITHSUNDEEP
excelexcel-formulapivot-table
user3067028
user3067028

Reputation: 159

Show % in PivotTable

I have a pivot table in which I want to show on time delivery %:

SO26642184 question example

My "on time lines count" is the total amount of lines I have shipped on time. The total lines count is the total lines count regardless if it has shipped on time or not. For example my on time delivery % on month 1 should be 79.8% which is 1227/1537.

How can I get this to show inside of my pivot table.

Upvotes: 1

Views: 701

Answers (3)

Lucas Motta
Lucas Motta

Reputation: 145

To solve the problem of your PivotTable, you can create a calculated field and format as a percentage, this will work, I reproduce your example and it worked...

Link example

Mega

Upvotes: 0

MattClarke
MattClarke

Reputation: 1647

If I were in that situation, I'd probably put a formula like the following all the way down Col D (assuming the pivot table is in cols A:C):

=if(c6="","",b6/c6)

That will show the percentage you want where it is relevant and empty cells elsewhere, and will continue to do so when the pivot table is refreshed.

Upvotes: 0

pnuts
pnuts

Reputation: 59475

Add a Calculated Field with Formula: 

=On Time Lines Count / Total Lines Count

Upvotes: 1

Related Questions