atlascanada
New Member
- Joined
- Jul 1, 2014
- Messages
- 10
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
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