Values in Pivot chart not correct

see attachment, but I'm afraid a pivottable isn't the right tool for what you want.
It makes a kind of a tree for your 447 possibilities and that creates restrictions.

170 for your "raising request rating" is a subtotal somewhere in that table, so you can request it in a formula, because it's in the 1st column of the rowrange of the pivottable.
Unfortunataly, this can't be done for example "timeliness rating", because all subtotals are already combinations with the previous columns.
I have no idea how to present you a kind of 6D-model with your numbers.
For an individual question of a subtotal, a formula with sumproduct is possible.

As a kind of workaround you can also drag and drop "timeliness rating" as 1st option in your rowrange (manually or with VBA), so that you can have the detailed view on a specific side of the 6D-model.

It looks like you could use PQ to unpivot the source data and then make a pivot table off that connection. See attached, which may be what you want.