Reporting Metrics from Table
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 made the table just am not good with pivot.
Did you really mean to post a blank worksheet (except for shaded rows)?
Ben Van Johnson
Oh no. I am sorry no I did not mean to do that.
In the event that the statement "I have made the table just am not good with pivot" means you need some help producing pivots, the PT sheet displays two pivot tables. The directions for producing two pivot tables on the same sheet are listed in the following article: https://www.techbout.com/two-pivot-t...orksheet-4072/
In the event that the statement means that pivot tables are not wanted Sheet 9 is populated using formulas similar to:Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks