GetPivotData Empty Strings and Data Fields

Catchy title I think you’ll agree - GETPIVOTDATA click bait if ever I saw it…

pivot tips getpivotdata