Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table of data:
Category 1 | Category 2 |
---|---|
A | A-1 |
A | A-2 |
A | A-3 |
B | B-1 |
B | B-2 |
C | C-1 |
C | C-2 |
C | C-3 |
C | C-3 |
C | C-4 |
I want to add the field based on the rank of the count of category 1, such that:
Category 1 | Category 2 | New field |
---|---|---|
A | A-1 | 2 |
A | A-2 | 2 |
A | A-3 | 2 |
B | B-1 | 3 |
B | B-2 | 3 |
C | C-1 | 1 |
C | C-2 | 1 |
C | C-3 | 1 |
C | C-3 | 1 |
C | C-4 | 1 |
Based on the new field, I want to create a chart which only shows the count of category 2 where the value of new field is 1.
Category 2 | Count(Category 2) |
---|---|
C-1 | 1 |
C-2 | 1 |
C-3 | 2 |
C-4 | 1 |
Could anyone give me some clue how to do it? Thanks a lot!!
Did you get a chance to look at my response here