How can you create a summary sheet of another sheet in Calc [closed]
Consider this Calc file:
- Sheet Complete has a table with 8 columns
- Sheet Summary should be a summary of that table:
-I only want to see 4 of the columns
-I only want to see the rows whose Type is "Cash" in the Complete sheet
Is it possible to auto-build the Summary Sheet from the Complete sheet? How would it be done?
Upvoted your question as you provided example, you should now be able to attach files to your questions. If you could please attach files in future instead of adding links to external sites
Thanks @mark_t! However I believe I'm unable to edit the question to upload the example directly. (and you're right, I needed to use an external service since I didn't have permissions to upload a file)