I am quite new to Calc, so please be gentle.
To explain here a sample table of an imaginary hair salon entrepreneur.
Customer Blonde Brown Black Highlights HairLength
-------------------------------------------------------------
Monica Yes No No Yes 15
Bianca No Yes No No 75
Lena Yes No No Yes 45
Selma No No Yes Yes 35
Kelly No No Yes No 45
I have several sheets like this in one spreadsheet (one sheet per salon). I now want a master sheet where I can display information from all Salons. For example:
- all blonde customers
- all blonde customers with highlights
- all brown or black haired customers without highlights
- all brown haired women with highlights and hair at least 35 long
These can be displayed in fixed columns on the master sheet, since I need the same information again and again.
Ideally I also have a selection list that has entries according to the table head ("Customer, “Blonde”, “Brown”…). On selection Calc should display the names of the customers as taken from across all sheets.
Things like this. You get the idea. I basically want to query the data on these sheets to get a statistical overview of the business.
Is this even doable or do I better start learning Base?