Hi, I am looking for an explanation for the values I am seeing. To outline the problem:

1. I want a pivot table that shows each item as a percentage of the row total, but i want to retain the grand total count, so I was going to make calculated items for each field.

2. The problem is the formula I have as "Percent1", and all the "Percent" Items, is supposed to be the sum of the value/sum of Gtot. for the attached workbook, i would think that this would be 5/55 or 9%, instead it is showing up as 76%

Can someone explain this? or better yet, offer a solution? I would really appreciate it.
example for upload.xlsx