CODEWITHSUNDEEP
excelexcel-2010pivot-table
Toby
Toby

Reputation: 145

Excel 2010 Pivot Table issue

I have the below pivot table

Category    Total Count(calculated value)      # Completed Count(calculated value) 
  Red        38,357                                 18822
  Blue       182                                     155
  Green      7,153                                  4,761

I would not like to calculate a % of the two counts. So show the % of 18,822/38,357, etc. How would I go about getting this metric?

Upvotes: 0

Views: 32

Answers (1)

Toby
Toby

Reputation: 145

Insert a calculated Field. In the formula box divide by the true column name. So for instance if it's a calcululated value Count of "xx" exlcude the count of and use only the column name.

Upvotes: 1

Related Questions