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!!
