Skip to Content
Nov 15, 2016 at 08:50 PM

Count of duplicate values in a column - Web Intelligence


Hello All,

I have a Webi report with multiple columns, I'm trying to get a count of all the unique rows in column "Mesh Group" (as displayed in attachment 2). Basically, the column "Number of mesh group" which is right next to "Mesh Group" needs to display the count of all unique/duplicate values. For ex: "KM2" appears 2 times within the report, hence the "Number of mesh group" value must show 2 next to "KM2".

I have tried the count, count all & distinct functions so far, with no success. Can someone please help create a function that will achieve this for me ?




current.jpg (51.4 kB)
desired.jpg (64.0 kB)