I want to display a summary of values from multiple lists in one table. Each list will have the same subset of Yes/No columns. The summary table will have row for each list and a column for each Y/N column. The values will be the total for each column for each list. There will be a summary row at the bottom.
Is this possible to do out of the box, SPD or something like Excel services? If so, what tools would I use to do this? Right now, I can only see this being done with a little bit of custom dev.
Example of the desired output:
List Col 1 Col 2 Col 3 List 01 1 8 5 List 02 4 3 1 List 03 2 2 3 Total 7 13 9