Is it possible to display a summary of statistics from a certain attribute within a feature class within the print composer using an sql statement. I have an shapefile "projects" with a number of features and attributes such as location, author, value, etc etc. I would like to provide a simple table or text box within the composer that displays statistics based on a certain attribute. For example i would like to show the sum of all the "value" attributes for a given "author". something like
Sum('projects'.'value') where 'author'=XXX
Therefore, if i change some of the attributes in the table, such as the value of a project or author of a project, the text in the composer would update automatically.
Ideally i would like a composer that shows on the map all of the features (coloured by author for example) and then a summary table for each author with a feature count, total value, and any other summaries etc.