Hello all. General pivot table question - I feel like there is a very easy fix to this, but I keep getting the error message "we can't create a timeline for this report because it doesn't have a field formatted as Date" when I try to insert a Timeline because there are blank date cells. It seems to work fine when there are no blanks.
Suggestions? How do I get around this? I cannot fill in the blank cells as there is no associated date to enter and I don't want to put a value in them.
Suggestions? How do I get around this? I cannot fill in the blank cells as there is no associated date to enter and I don't want to put a value in them.