Hope someone can help a very simple question. I'm trying to build a table with a simple total of amounts per year e.g.
2010 2011 2012
Count(ID) Count(ID) Count(ID)
The query underneath is just doing a basic select of a number of fields off a table, no grouping or aggregation of any kind.
The way I initially tried to do this was create a column group of year, with a count wrapped around each ID. I thought that it would group the count per the column group but this was not the case. Instead it performed a count of 1 as in 1 instance of each ID.
As a work around I simply added a total underneath the ID (Details) column which performed the count per year correctly, however I had to make the details row invisible in order to get it to appear correctly.
I know that it might be easier to perform the aggregation in the actual query or perhaps to use the matrix (although I don't want a row grouping) but if someone can direct me if I'm just missing something with tablix grouping it would be appreciated.