I have a mail-in database that I am using to let me know when users click a button. It sends a mail message to this db when the user clicks. Some users click the button more than once…so I get multiple lines in the mail-in db. I don’t want to have to go in and manually delete the duplicate documents. Is there a way to display only one entry in the view even though there are multiple mail messages? I only have 2 columns in the view, From and the count (I am keeping a count, so if I categorize, it counts the duplicates too). I tried @Unique(From) in the column but that didn’t work.
You are actually very close you are just counting the wrong column. Place the column next to the categroized one and count it, but use the property that says “hide detail rows” in the column properties. This will give you a count of the categories only
I have the first column sorted and categorized. The second column I have has a formula of “1” and it is totaled and I clicked Hide Detail Rows but Notes is still coming up with multiple counts…am I missing something?