Mar 14 2019 11:26 AM
I am trying to create a spreadsheet to show a p/l statement. I want to display figures and hide rows with the information that shows where the figures come from.
Using the example blow. I want to hide the rows with the week ending payroll numbers but want to have a dropdown feature on OFF. Payroll cell to show where the figures come from.
REVENUE | |
OFF. PAYROLL | 800 |
week ending 3/5 | 300 |
week ending 2/27 | 500 |
LABOR | |
LOGISTICS | |
GROSS PROFIT | |
OFF EXPENSE | |
NET PROFIT | |