Hello, I'm creating pivot tables for data trending by month but sometimes there is no data for a given month. Is there an easy way to fill in a line with the month that has no data? I'd like to see how things perform over time. Thanks!
Hello, I'm creating pivot tables for data trending by month but sometimes there is no data for a given month. Is there an easy way to fill in a line with the month that has no data? I'd like to see how things perform over time. Thanks!
One way is to have the month in there but assign a value of zero to its data. This may not be technically correct, since nothing does not always mean zero. This may get your over the hump with the pivot table, but it may not work as well if you are looking at a line or bar chart of some sort.
________________
[1] If this reply was helpful, click the star to the left.
[2] If this reply answered your question, mark this thread as [SOLVED].
Last edited by Dimitrov; 10-20-2013 at 03:29 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks