Hey,
My title may not have helped. I have a column that displays whether someone was late or not to a job (yes or not), is it possible to create a pivot that displays, the location of job, number of jobs, and number of jobs on time (or late)?
I've attached an example
Thanks
hi there. i have attached 2 ways to go about that. see if that helps
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thank you benishiryo,
Do you know if there a way to delete/hide the no column from the display but keep the yes and total?
Thanks
hmmm. i only know how to do that through PowerPivot but i don't have it in my computer though.
I don't know if the Excel 2011 for Mac support DataModel but if this exist (you can check under Data - Data Tools - Manage Data Model) you can hide column(s) from PivotTable Fields - Hide From Client Tools
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks