Consider you have a list of sales, with Date,Category,Description,Value,etc
The list has a lot of sales of XX,YY,ZZ and so on.
Now consider you want to create a sub-report sheet which is a abridged view of this. In particular:
- You only want to show some of the original sheet’s columns
- you only want to show the XX
See the attached example.How to create subreport.ods
This is something that I struggle regularly with. If the report makes calculations (e.g. sum), I manage with Pivot Tables. But I struggle with a “show the exact same data, but an abridged view”.