Within a list, I have two drop down choices. I want to create a calculated column(S) to count each combination of the two choices.
So if C1 can be a,b,or c, and C2 can be x, y, or z.
count how many times each situation is picked A-X, A-Y, A-Z, B-X, etc
EDIT: The end state, is to use this calculated value in a graph, so I need to be able to reference it in a graph web part. Right now, I'm using a table, which I populate manually by using the group-by method below.