How to create a Sub-report with only some columns and some rows in Calc

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”.

Any suggestions?

Please attach the file with a sample of what you have done with PT and what you want achieve?