Forum Discussion
Adding data to an aggregate?
My project has an unusual business requirement. I have a bunch of records where each record belongs to one of a few groups, along with a pass/fail value. I want to be able to get the count of how man...
You can use query editor for this as well. Filter out all the secretive group records from your main table and later on create another query only of secretive group. Use Groupby feature in Query editor and finally append the query on top of your first query.
Would you please post a sample data for us to create a solution using multiple approaches. It would be new learning for everyone.