Hi,
I have a pivot table which is connected to data from another document. On some cells they are blank and have no data for that day. However, the blank cells shows a 0 on my pivot table and there for show zero on pivot chart...
How do i make the blank cells remain blank on the pivot table and also show as blank on the pviot chart.
Thanks.
Bookmarks