I'm currently working with information that is tracking sales by month and by item. They are labeled by the month in text form (i.e. November) rather than 11 or something of that nature. Is there a way to sort them by month without having to change them to a numerical date?
Also, when I try and make a chart it doesn't allow me to total the amount purchased, rather the amount of times something was purchased by month. Is there a way to fix this? i keep trying sum (total due) but it is giving me the count of total due instead.