Count against Dim2

[sylvesterjesuda]

Hi,

I have a example data like below in which I would like to take the count of Dim 2 against Dim 1.

(ie) In the Chart, I want Dimension as Dim1, In the expression, I want the Count 3 for A.

Can anyone help to bring the solution for it, since if I use the count formula, I get the count for A as 2 which is wrong.

Example Data:-

Dim1	Dim2
	A
A	B
B	A
C	D
	A
A	B
B	C
C	D

Best Regards

Sylvester J

[vishsaggi]

Why you have to get three? Is the above data sample right?

[sylvesterjesuda]

Yes its right... Its just like we use Countif function in excel

See the result in excel below, how can it be done in expression as result where the Dim1 should be in expression.

Dim1	Dim2	Result
	A	0
A	B	3	=COUNTIF(B:B,A3)
B	A	2
C	D	1
	A	0
A	B	3
B	C	2
C	D	1

[vishsaggi]

May be this?

= COUNT (TOTAL <Dim2> Dim2)

[vishsaggi]

May be rwunderlich‌ stalwar1‌ can give any suggestions or ideas please...

[Lisa_P]

Why are you loading Dim1 ? Is it to limit Dim2 values ? There is no relevance to the row levels.

If you only load Dim2, you can count how many of each one, the only thing you are looking for is matching the Dim1 values.

[tamilarasu · Accepted solution]

Hi Sylvester,

Try this.

Substringcount(Concat(Total Dim2,'|'),Dim1)

[sylvesterjesuda]

Heartful Thanks Tamilarasu, Your answer is perfect and it is an timly help....