i am looking for % by row... so 7 has only one tag, the other 2 numbers have 4 tags so percentages for those numbers will be about 80%, 5%, 10%, 8% for number 8. Something like that but i cant make the pivot table produce any percentages.