Results 1 to 5 of 5

Showing blank field within pivot table

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-02-2013
    Location
    Hollywood, Fl
    MS-Off Ver
    Excel 2010
    Posts
    110

    Showing blank field within pivot table

    Hello all,
    I have a question concerning pivot tables. I had a pivot table that I would refresh monthly. It would show all of the months for the entire year, but there would only be values within the months that had data. I was originally pulling the values from a calculation I was doing within the data file. Recently my boss went in and changed the pivot table to perform the percentage calculation in the pivot table rather than grabbing the value from the data source. Now, I have #DIV/0 for the months of Oct-Dec, because there aren't any values for those months within my data tab. Does anyone know how I can keep the formula within the pivot, and still be able to show the full year without having Oct-Dec show #DIV/0? I have attached an example of the pivots to show you what I am talking about. Thanks for any and all help!

    Damian37
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 01-24-2014, 09:52 AM
  2. vlookup field not showing in a pivot table...?
    By highlystrung in forum Excel General
    Replies: 3
    Last Post: 04-14-2011, 02:38 AM
  3. Pivot Table, Blank Field and Grouping
    By Bon.Scott in forum Excel General
    Replies: 1
    Last Post: 05-07-2010, 05:46 AM
  4. [SOLVED] pivot table not showing field list
    By bobteixeira in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-16-2006, 09:50 AM
  5. How can I show all field data in a pivot table, instead of blank
    By Alastair Scott in forum Excel General
    Replies: 3
    Last Post: 08-17-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1