Hi -
I was able to recreate the pivot table / dashboard in the webinar. Everything seems to work OK, but - I noticed that the slicers for states SA and TAS seem to throw a nasty #REF! onto the pie chart whenever they are selected. (I realize the source data has nothing available for Fashion Direct sales in either SA or TAS, as evidenced by the gap in the sparkline chart.)
Just wondering if anyone might know of an easy fix for this(?). I know it's easily explained due to the data gap, but for the audience, it might give them an uneasy feeling that maybe the dashboard isn't working correctly. I'd much rather see an "N/A" or a 0 displayed, myself. Any thoughts......??
Thanks! -
Hi C.J.
You need to set the Chain field in the Pie Chart PivotTable to show items with no data as stated in step 5 of the 'Build Steps' sheet. This is the same in step 6 for the Sparkline Pivots.
Let me know if it's still throwing errors.
Mynda