+ Reply to Thread
Results 1 to 2 of 2

Can Pivot Table display 0 if there's no data?

  1. #1
    Registered User
    Join Date
    02-22-2013
    Location
    Materion
    MS-Off Ver
    Excel 2010
    Posts
    13

    Can Pivot Table display 0 if there's no data?

    I have a pivot table that displays dollar values per week of the year. If there is no data, it skips over the week completely and doesn't list it. Can I set it so that it displays a 0 instead of ignoring it?
    Thanks!

    Edit: I don't think I accurately described my problem. I understand why the week does not display. My real problem is I'm trying to do a VLOOKUP for the data in the pivot table. If that particular week is not found within the pivot, it displays a #N/A error. I would like it to display a 0 there instead.
    My formular currently looks like this: =VLOOKUP(A5,'Return pivot'!D5:E164,2,FALSE)
    I hope this makes more sense.
    Thanks!
    Last edited by Dan.Reynolds; 05-06-2013 at 01:33 PM.

  2. #2
    Registered User
    Join Date
    04-30-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Can Pivot Table display 0 if there's no data?

    It sounds like you need an IFERROR calculation.

    Try =IFERROR(VLOOKUP(A5,'Return pivot'!D5:E164,2,FALSE), "0")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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