Count of String in expression

[#1]

Hi All,

Looking for product count  based on product ID in expression but product  Count should display  product name (string) ..like how we display in table and  count should be  4.

Product ID	sum(sale)	Product Name	Product count
1	10	ABC	ABC
2	20	DGC	DGC
3	10	JHG	JHG
4	20	HBC	HBC
Total	60		4

Thanks in advance

[Anil_Babu_Samineni]

Why not, Simply Count([Product Name])

[Anonymous]

Is that you want to display

1. Product name in Product count field? and
2. in Product count field - total you want to display 4 ?

[varshavig12]

Something like this ,

[#5]

Yes i want to display 

1. Product name in Product count field and
2. in Product count field   i  want to display total count  4 . This total count is based on  Product ID

[varshavig12]

Output:

Dim:

Exp:

[Anonymous · Accepted solution]

Try this expression: if(Dimensionality() = 0, Count(DISTINCT [Product ID]),  [Product Name])

Hope this is helpful to you.

[varshavig12]

Kavya can try it.

[#9]

Hi Kavya Shree,

I think are you Expecting only total count? if yes,Do like this

Just write the Expression If(product-id = product-id,' ')  just give the space

and select text count inTotal mode.

then you get out put like this

[#10]

Thanks everyone