ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to i pivot a table using various criteria (https://www.excelbanter.com/excel-worksheet-functions/86716-how-i-pivot-table-using-various-criteria.html)

Emmal

how to i pivot a table using various criteria
 
i want to create a pitvot table using various criteria. this is for a
diversity report.
eg

gender salary age
male female <25 26-30 31 <21 22-30 30
1 1 1
1 1 1

how can i create a table that shows me (eg) all <21 year old males earning
over 31K


All times are GMT +1. The time now is 06:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com