How many dependants does 'AB1' have

[tinkerz1]

Hi,

I will try an explain what I am trying to do:

Field A    Field B

AB1           DE

AB2           DE

AB3           DE

AB4           DE

AB3           FG

AB1,AB2,AB4,AB5 has 1 dependant

Where as

AB3 has 2

How can I write an expression to find this out?

Thanks

[MK_QSL · Accepted solution]

Create a Straight Table

Dimension

[Field A]

Expression

Count(Distinct [Field B])

[tinkerz1]

Sorry,

That does not produce any data, it should produce

AB1   1

AB2   1

AB3   2

Many Thanks

[robert_mika]

Manish is correct:

[sunny_talwar]

Seems to be working as Manish prescribed: