database creat two reports

SDKBRK

Board Regular
Joined
Feb 1, 2003
Messages
162
I have a database that consist of AREA#, JOB CLASS, ID#, EMPL NAME, pHONE#, REFUSED, WORKED, TOTAL

I have to enter the numbers hours overtime or refusal. If employee changed areas or has a new Job Class each week. Then send 2 reports out. One sort by Area then Job Class, the other by Job Class then Area.

I need these two reports seperated by border or row so it does not just run together.

The report by AREA needs to show Area and then Breakdown by Job Class then the employee with the least amount of ours to be the frist from that job class. I can enter it on each report and not have a main database but just looking for the easies way.

Any suggestions.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
nameareajobclassrefusedworked
fredA1J1321
billA1J1422
johnA2J2523
amyA3J2624
fredA2J3725
johnA2J3826REFUSED
A1A2A2A3
J1J2J3J2
fred3070
bill4000
john0580
amy0006
WORKED
A1A2A2A3
J1J2J3J2
fred210250
bill22000
john023260
amy00024
formula in cell returning 3 (fred / A1J1)
=SUMPRODUCT(($A$2:$A$7=$F11)*($B$2:$B$7=G$9)*($C$2:$C$7=G$10)*($D$2:$D$7))

<colgroup><col span="5"><col><col><col span="2"><col><col span="4"></colgroup><tbody>
</tbody>
 
Upvote 0
I have my pivot table by AREA then JOB CLASS now how do I get it to sort by total hours. EACH AREA HAS JOB CLASSES AND EACH ONE HAS TO BE SORTED BY TOTAL HOURS so we will call the correct person to work overtime in that area under that job class.
 
Upvote 0
you dont have to understand my formula - accept I produced the 2 tables...........

many ways of doing this....
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,273
Members
448,559
Latest member
MrPJ_Harper

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top