putting one of the Data columns as the Data. It becomes "count of dataX" and the result of the Date column should be sortable.
I have data dumped from a database into my main sheet. Each row is timestamped in the DD-MON-YY format. For ex: 02-OCT-09 or 11-AUG-09.
I am trying to arrive at a simple list of how many entries are there per date, sorted by date.
SO a list such as:
I created a Pivottable with the Date field as the Row Label and Values as the count of the Row Label. THe counts come out fine but I cant seem to find a way to sort the dates in increasing order. The only sort options are A-Z and Z-A.