Reporting Metrics from Table

**bjohnson0916** · 05-21-2019, 03:29 PM

What I want to track is the time it takes to reach ratio each time ratio is checked, there are a minimum of 2 ratio checks per pump per day. The information gathered needs to tell:

By Foreman
Time Duration for each Ratio Check
What Pump is being Used
What FP Material is being Used

By Pump
Time Duration for each Ratio Check
What Foreman
What FP Material is being Used

I have built the table but have such a problem with pivot.

**alansidman** · 05-21-2019, 03:37 PM

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here. I am, therefore, closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...rom-table.html

Please read our forum rules that you agreed to abide by when you joined.