Pivot table does'nt show row grand totals

Hello,

I have been fighting a couple of hours getting the grand total for the rows in my pivot table.
I have attached a picture of my worksheet showing the problem. picture.PNG

Especially, I would like to have frequencies in terms of fractions relative to the total row (ie. in the attached; The percentage of the people asked about "bus" who answered "very good" ie. 10/18=56%)
However when I choose to "show values as % of row total" all the rows show "100 %" I suspect, the reason is the same as why Excel won't show the grand total of the rows.


I would really appreciate any help - thank you in advance!

These might help
https://www.excelforum.com/excel-gen...to-appear.html

https://www.excelforum.com/excel-cha...rcentages.html