Hi, how to display a particular data combination, across multiple fields, and the number of times each combination appears in the dataset? example below. Thanks.
rowno() as row in your table
and use row into your table above and use straight table
and hide row field using Presentation-> select row expression and check hide
hope this helps
Hi, does rowno() count the number of rows with the same records?
Atually I didn't understood your point,
But taking Date, Site and Person as dimension and
count(date&site&person) will also give the count of combination of records.
If it do not helps , please elaborate more abt your req
Basically I want to count the number of duplicate rows for each distinct combination. I want to use recno function but I don't know which part of the script to write it. Thanks.
Just the count(date&site&person) will give the number of rows for the combination. you wouldn't need to use Recno.
If you have any sample data then share it, this will help a lot.
You can directly use count for counting the combination value either count(Site) or count(Person) will give you same result till they are in range of date.
Retrieving data ...