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

1. ## 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!

2. ## 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")

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

#### 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