I see the category and category rollup reports, and I want to make my own type of report. How do I go about doing this?I understand that it’s going to be a script-writing exercise, but I’m a bit confused as to where to start.
Pivot tables and the QUERY function are a couple of popular ways.
Pivot tables are more point-n-click guided without worrying about formulas.
QUERY is a very powerful function that is more readable than some cryptic looking formulas can be.