How to count a field which has a common value with other fields?

[Anonymous]

In the above table, the value "ADAPTER" in ITEM NAME field is a common value for both "VO" and "PTO" of DIV field.

I want to count how many such values in ITEM NAME has the same characteristic.

Please assist.

[sunny_talwar]

May be this

Count(DISTINCT {<[ITEM NAME] = {"=Count(DISTINCT DIV) > 1"}>} [ITEM NAME])

[Anonymous]

shall I use this same as it is ?

or I have to enter the values like "PTO" and "VO" anywhere ?

[arvind1494]

Count(DISTINCT {<[ITEM NAME = {'=Count(DISTINCT DIV) > 1'}]>} [ITEM NAME])

[sunny_talwar]

Just try it as is

[Anonymous]

it is giving distinct count value for each ITEM NAME.

I need count for each ITEM NAME value having "VO" and "PTO" in DIV field.

Eg; For the above table, the count value for "adapter" should be one and the same for "actuator" as well.

[sunny_talwar]

I am not sure I follow... is this what you want?

Dimension           Value

ADAPTER               1

ACTUATOR             1

[Anonymous]

yes, correct!

[sunny_talwar · Accepted solution]

I used this expression

Count(DISTINCT {<[ITEM NAME] = {"=Count(DISTINCT DIV) > 1"}>} [ITEM NAME])

and got this

What is wrong?

[Anonymous]

Thanks Sunny and Arvind..