Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this expression: if(Dimensionality() = 0, Count(DISTINCT [Product ID]), [Product Name])
Hope this is helpful to you.
Why not, Simply Count([Product Name])
Is that you want to display
Something like this ,
Yes i want to display
Output:
Dim:
Exp:
Try this expression: if(Dimensionality() = 0, Count(DISTINCT [Product ID]), [Product Name])
Hope this is helpful to you.
Kavya can try it.
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
Thanks everyone