get percentages in pivot table?

[atlascanada]

I have 3 columns of data: animal (deer, fish, bear) /completeness(incomplete,complete, fragment) /level(1,2,3,4,5)

I wonder if there is a way to have a pivot table with animal down the side, level along the top and in the middle just the percent of "complete"

for instance there in level 1 there are 4 fish, 2 are complete and 2 are fragments, so i would like it to read "50%"

is this possible? or is there a way to do it without a pivot table?

any help would be great! thanks

 

[NiMip]

You can get that result, but it's a bit busy-looking and the only way I can think to only show % complete is to hide rows. I'm not a huge user of PivotTables though, so someone might have a good way to clean it up.

Once you've created your PivotTable:
1. Add "Level" to Column Labels
2. Add both "Animal" and "Completeness" to Row Labels
3. Add "Completeness" to Values
4. With a result in your PivotTable selected, in the ribbon under PivotTable Tool > Options > Calculations > Show Values As, select % of Parent Row Total
5. (Optional) Hide the rows containing incomplete and fragment

If you want to do this without a PivotTable, you could manually create your list of animals as row headings, levels as column headings and use a formula like:
=IFERROR(COUNTIFS(animalRange,$A2,levelRange,B$1,completenessRange,"complete")/COUNTIFS(animalRange,$A2,levelRange,B$1),"No Result")

	A	B	C	D	E	F
1		1	2	3	4	5
2	deer	14%	0%	0%	25%	71%
3	bear	0%	67%	33%	29%	20%
4	fish	29%	50%	43%	0%	0%
5	crow	100%	33%	50%	71%	25%
6	magpie	No Result	67%	0%	40%	25%

<tbody>
</tbody>

 

[atlascanada]

perfect for what I needed. thanks a lot =)