hello,
I have some data I would like to organize using pivot table. Sheet 'report' contains date and time in Column A and error code in column C. I would like the date and time to be used in such a manner:
the date would be the parent choice, which is then branches off to time on a hourly bases showing the total count of error code. The sheet 'Results' shows how I would want the results to look like (Please note that the dates are sorted in results). I was able to use the 'group' feature of hours but then it does the entire thing hourly without separating dates. any help would be appreciated. Thanks
Bookmarks