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!
Bookmarks