Hi Olayinka,

Welcome to our forum!

Are you referring to the error from Dashboard sheet cell D6- =GETPIVOTDATA("Sum of No of Active Users (Visits)",'EShop Headline Pivots'!$A$3) ?

The error comes from your Raw data, rows 96-100 are empty, you have to remove them and press Refresh All.

In those calculated columns, never use such formulas without error check:

(F2-G2)/G2

If G2 is empty, you will receive DIV/0! error, so you have to check first if G2 is <>0, or use IFERROR:

=IF(G2<>0,(F2-G2)/G2,0)

Or:

=IFERROR((F2-G2)/G2,0)

An error will break the calculation chain, all subsequent formulas will display the same error.

Thanks so much for the correction & added advise provided above.

Yes, I was referring to the Dashboard sheet and the two EShop Headline Pivots sheet (cell 73 & 74 respectively) which have added blank spaces.

I'm thinking the errors affected the dates on the pivot charts in the Dashboard sheet, but I may be wrong too.

[[[[Note to Self: I'm taking that I should now always insert the IFERROR FORMULA to avoid any such re-occurrence.]]]] 😀