With Reports (at least for me) it’s mostly a matter of trial-and-error, play with all the available options until you get something that works, or give up…
If all fails, you can try Google graphs, see here:
Google graphs can have a “table” format where they look like Reports essentially.