[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 70
  • Last Modified:

Pivot table report filter does not display blanks as a selection option

Hello,  

I've created an Excel pivot table by automation from access.  When I open the created workbook, all the data apppears to be there, including any that contain blanks.  When I apply a filter to those fields, blanks appear as a selection option.  However, If I use a field that contains some blank cells, and set it as a report filter on the pivot table, blanks do not appear as an option in the report filter
0
chtullu135
Asked:
chtullu135
  • 2
  • 2
1 Solution
 
Katie PierceCommented:
That's interesting.  I ran a Pivot Table myself to test it out, and I found "(blank)" at the bottom of the drop down list for the filter.

Can you upload a sample so I can see the problem?
0
 
Katie PierceCommented:
Hi chtullu135, have you had any success on this issue?
0
 
chtullu135Author Commented:
Yes I did.  It started to work for me and I posted my reply but for some reason I am having trouble posting replies from work.
0
 
chtullu135Author Commented:
I tried shutting down and restarting my computer.  It then started to work.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now