software

In the database we use SALES figures are listed per day.
I would like to group them per week, per month in a pivot table.
I've tried quot;Groupingquot;, but get an error message.
Who can point me in the right direction to get this done?--
digicat
------------------------------------------------------------------------
digicat's Profile: www.excelforum.com/member.php...oamp;userid=14920
View this thread: www.excelforum.com/showthread...hreadid=499205Hi

Make sure that all of the data in the range are true Excel dates.
Text values, or blank cells in the range will cause the error message
quot;Unable to group that itemquot;.

--
Regards

Roger Govierquot;digicatquot; gt; wrote in
message ...
gt;
gt; In the database we use SALES figures are listed per day.
gt; I would like to group them per week, per month in a pivot table.
gt; I've tried quot;Groupingquot;, but get an error message.
gt; Who can point me in the right direction to get this done?
gt;
gt;
gt; --
gt; digicat
gt; ------------------------------------------------------------------------
gt; digicat's Profile:
gt; www.excelforum.com/member.php...oamp;userid=14920
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=499205
gt;