I have created a pivot table counting the number and percentages of a field which has two characteristics called Updated and Not Updated.
As I wish to show the amounts in an interactive dashboard, I have added text to a GETPIVOTDATA formulae which is in turn drawing the data from the pivot table.
Within the dashboard I have slicers showing quarters, however in some quarters only one of the (Updated and Not Updated) fields are showing.
This is creating a #REF error when there is no data in the pivot table and the respective quarter slicer is selected.
My question is, is there a way of showing the missing field as 0% when there is no data for that quarter, I have added some screen shots for reference.
Use IFERROR:
=IFERROR(GETPIVOTDATA(....),0)
How???
More instructions please
Replace your current GETPIVOTDATA(...) section in the relevant formula(s) with IFERROR(GETPIVOTDATA(...),0)
