I have a View that uses aggregation to count the number of nodes of a custom color type. For example, there are 10 red nodes, 10 green nodes and 20 blue nodes. For each color, I would want it’s node count and the total count to show up on each row, like this:
Color Count Total Red 10 40 Green 10 40 Blue 20 40
Ultimately, I do want to calculate the percentage in each row as well, but for now I’d just like the total.
What’s the most efficient “drupal” way of doing this?