Rank using dimension not shown in chart

[Anonymous]

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

[sunny_talwar]

Did you get a chance to look at my response here

Rank of dimension not used in chart