Solved

counting blanks in pivot table

Posted on 2014-10-23
5
47 Views
Last Modified: 2014-10-23
I have included the problem details in the attached excel file.

Thanks,
Pivot-table-Count-Blanks-Qsn.xlsx
0
Comment
Question by:techEverest
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 40399819
Instead of doing a count of "Details" in the Values section, do a count of OS instead.
count of OSRegards,
-Glenn
0
 

Author Comment

by:techEverest
ID: 40399832
Great Glenn. That was helpful. Now the other thing i would like is to get counts of blanks separately for Apple blanks and Windows 7  blanks and not show total blanks at the bottom as I got with this solution.

Thanks,
0
 

Author Comment

by:techEverest
ID: 40399873
Oh Glenn, I didnt see the screenshot. Thanks for your quick help. This was great.
0
 

Author Closing Comment

by:techEverest
ID: 40399874
That was quick. Awesome Glenn.

Thanks a lot.
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40399945
You're welcome.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question