The Pivot table is as below:
Values
Row Labels
Sum of ID
Sum of Risk Level
A
69
12
B
141
32
Grand Total
210
44
This Pivot Table gives the cross table of all the variables at different possible levels.