Search the Community
Showing results for tags 'group by'.
I want to create a view that will give me unique values for an activity with an entity, while the table stores activity, entity and sometimes multiple contact persons per entity. I want a chart and a report that shows the number of activities with each entity (and do not want those entities with multiple contact persons to count / shown multiple times). Is there a way to create so-called Group By views, or is there a way to structure a report in such way that The multiple contacts are not shown?
I have two tables - accounts and invoices. I want to create a tabular report where each record contains the sum of AccountBalance by AccountType and uses calculated fields to return data from the invoice table. How do I create a tabular report that is first grouped by AccountType so that I can eliminate multiple rows and provide a higher level report? Can this be accomplished with a view of Accounts? ACCOUNTS Account# AccountType AccountBalance 1 1 50 2 1 50 3 2
Hello, I'm using a tabular search and report for an invoicing application where I need to show aggregations of the RateAmount grouping by the RecIDL at the bottom of the RateAmount column. I want to pass the aggregated calculated field total to the invoice using an href link to my details page. Currently the link to the details page is showing an invoice for each RecIDL. I need the RecIDL to group on the tabular search and report with the aggregated total for each RecIDL. Here are the specifics: The Table name is 'Invoicing'. I have columns for 'RecIDL'