I am in the middle of a project where I need to show the different course offerings at a number of local schools, organized by level (apprenticeship through B.S. degree). I figured out how to get Excel to stop counting blank fields and adding them to my totals, so my numbers are at least accurate now, but when you click on the school name I want it to open up with a tidy list that shows exactly which programs and degrees are offered at that school, and instead I get something that looks like this:
(blank)(blank)(blank)Is there a way to get the pivot table to ignore the blank cells? It is so visually distracting, I'm embarrassed to turn it in like this. I'm just learning about pivot tables for the first time on this project and I'm sure the solution is something simple and obvious, but I've tried everything I can think of. I've unticked the "blank" field, I went into field settings and told it to only count numbers, I tried telling it to show a blank space for empty cells...I even tried to rearrange the data to avoid blank cells, but that isn't a good long term solution as I still have at least a dozen more schools to add and I'm running out of time...I'm at a loss. Any ideas?Short-term certificate
Thanks!
Attachment 202968
Bookmarks