I've created some relationships between tables in PowerPivot and occasionally I will have values that are un-matched. I want all of these non-matches bucketed into a single category, but by default these get labeled (blank) in a Pivot Table. Is there a way to replace that (blank) with a different value? If doing this in normal Excel, I would do something like,
=IFERROR(VLOOKUP(...),"Value to replace (blank)")
=IFERROR(VLOOKUP(...),"Value to replace (blank)")