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

asked 2019-04-04 10:11:19 +0200

migueldealmeida gravatar image

updated 2019-04-04 10:13:13 +0200

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?

edit retag flag offensive close merge delete


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

m.a.riosv gravatar imagem.a.riosv ( 2019-04-04 22:40:01 +0200 )edit