software

Hello all.
I've had great luck finding advice here, so I thought I'd try another puzzle.

I'd like a way to track sales by quarter, as well as month and year.
Currently, I used Excel group report feature that allows you to pivot out my
month and year, but it doesn't have an option for quarters. If I group the
quarters together on my main data worksheet, that negates the PT's
functionality, as it doesn't want to see any groups.
I'd thought of creating another column in the data worksheet that says Q1,
Q2, etc, but there's got to be an easier way.
I'm using XP Pro, Excel 2002. My date field is a numeric one, using the
format of xx/xx/xxxx.
Another thought was to break up the date entry into three separate field for
MO/DAY/YR, but that seems unecessary also.

Thanks,
PeterHi Peter

On the Pivot Table, right click on your Data field, and Choose Grouping,
then select Group by and choose Year, Quarter and Month.
They are not mutually exclusive and you will then get what you want.

--
Regards

Roger Govier
PSikes gt; wrote:
gt; Hello all.
gt; I've had great luck finding advice here, so I thought I'd try another
gt; puzzle.
gt;
gt; I'd like a way to track sales by quarter, as well as month and year.
gt; Currently, I used Excel group report feature that allows you to pivot
gt; out my month and year, but it doesn't have an option for quarters.
gt; If I group the quarters together on my main data worksheet, that
gt; negates the PT's functionality, as it doesn't want to see any groups.
gt; I'd thought of creating another column in the data worksheet that
gt; says Q1, Q2, etc, but there's got to be an easier way.
gt; I'm using XP Pro, Excel 2002. My date field is a numeric one, using
gt; the format of xx/xx/xxxx.
gt; Another thought was to break up the date entry into three separate
gt; field for MO/DAY/YR, but that seems unecessary also.
gt;
gt; Thanks,
gt; Peter
I have xl2003 here and it allows grouping by quarters within a pivot table.
Are you sure that 2002 doesn't also have the option to group buy quarters?

quot;PSikesquot; wrote:

gt; Hello all.
gt; I've had great luck finding advice here, so I thought I'd try another puzzle.
gt;
gt; I'd like a way to track sales by quarter, as well as month and year.
gt; Currently, I used Excel group report feature that allows you to pivot out my
gt; month and year, but it doesn't have an option for quarters. If I group the
gt; quarters together on my main data worksheet, that negates the PT's
gt; functionality, as it doesn't want to see any groups.
gt; I'd thought of creating another column in the data worksheet that says Q1,
gt; Q2, etc, but there's got to be an easier way.
gt; I'm using XP Pro, Excel 2002. My date field is a numeric one, using the
gt; format of xx/xx/xxxx.
gt; Another thought was to break up the date entry into three separate field for
gt; MO/DAY/YR, but that seems unecessary also.
gt;
gt; Thanks,
gt; Peter
gt;

Oops! My bad. Thanks Roger. Don't know how I missed that!

Peter

quot;Roger Govierquot; wrote:

gt; Hi Peter
gt;
gt; On the Pivot Table, right click on your Data field, and Choose Grouping,
gt; then select Group by and choose Year, Quarter and Month.
gt; They are not mutually exclusive and you will then get what you want.
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt;
gt; PSikes gt; wrote:
gt; gt; Hello all.
gt; gt; I've had great luck finding advice here, so I thought I'd try another
gt; gt; puzzle.
gt; gt;
gt; gt; I'd like a way to track sales by quarter, as well as month and year.
gt; gt; Currently, I used Excel group report feature that allows you to pivot
gt; gt; out my month and year, but it doesn't have an option for quarters.
gt; gt; If I group the quarters together on my main data worksheet, that
gt; gt; negates the PT's functionality, as it doesn't want to see any groups.
gt; gt; I'd thought of creating another column in the data worksheet that
gt; gt; says Q1, Q2, etc, but there's got to be an easier way.
gt; gt; I'm using XP Pro, Excel 2002. My date field is a numeric one, using
gt; gt; the format of xx/xx/xxxx.
gt; gt; Another thought was to break up the date entry into three separate
gt; gt; field for MO/DAY/YR, but that seems unecessary also.
gt; gt;
gt; gt; Thanks,
gt; gt; Peter
gt;
gt;
gt;

Yep, Roger pointed that out too. I goofed. Thanks for pointing it out!
Best,
Peter

quot;Duke Careyquot; wrote:

gt; I have xl2003 here and it allows grouping by quarters within a pivot table.
gt; Are you sure that 2002 doesn't also have the option to group buy quarters?
gt;
gt; quot;PSikesquot; wrote:
gt;
gt; gt; Hello all.
gt; gt; I've had great luck finding advice here, so I thought I'd try another puzzle.
gt; gt;
gt; gt; I'd like a way to track sales by quarter, as well as month and year.
gt; gt; Currently, I used Excel group report feature that allows you to pivot out my
gt; gt; month and year, but it doesn't have an option for quarters. If I group the
gt; gt; quarters together on my main data worksheet, that negates the PT's
gt; gt; functionality, as it doesn't want to see any groups.
gt; gt; I'd thought of creating another column in the data worksheet that says Q1,
gt; gt; Q2, etc, but there's got to be an easier way.
gt; gt; I'm using XP Pro, Excel 2002. My date field is a numeric one, using the
gt; gt; format of xx/xx/xxxx.
gt; gt; Another thought was to break up the date entry into three separate field for
gt; gt; MO/DAY/YR, but that seems unecessary also.
gt; gt;
gt; gt; Thanks,
gt; gt; Peter
gt; gt;


Originally Posted by PSikesHello all.
I've had great luck finding advice here, so I thought I'd try another puzzle.

I'd like a way to track sales by quarter, as well as month and year.
Currently, I used Excel group report feature that allows you to pivot out my
month and year, but it doesn't have an option for quarters. If I group the
quarters together on my main data worksheet, that negates the PT's
functionality, as it doesn't want to see any groups.
I'd thought of creating another column in the data worksheet that says Q1,
Q2, etc, but there's got to be an easier way.
I'm using XP Pro, Excel 2002. My date field is a numeric one, using the
format of xx/xx/xxxx.
Another thought was to break up the date entry into three separate field for
MO/DAY/YR, but that seems unecessary also.

Thanks,
Peter

Great stuff yaar.........
Sales tracking sales tracking software Sales lead tracking software