I have read up on Pivot tables, and you are supposed to be able to group dates into monthly totals in a Pivot Table, or Weeks, etc.
However as my list is daily I am following 'what I believe to be the set process of clicking on a date, selecting Grou & Show Detail to no avail.
Atm I am getting the error message.
"Cannot Group That Selection"
Any ideas/workarounds?
the date colum is formatted as Date.. \0:
Ty in advance.
Sp.
Bookmarks