Pivot Table Grouping

[farhanbutt1]

Hi

I have been given a load of data for a month and i need to make sense of it. I need to see at what time what orders have been taken. However the problem i am having is because each item which is sold to an account the count function is showing all the items sold in that hour.

I need the table to show for example

at in janurary at 9, 14 orders were taken.

any ideas please would be helpful

[etaf]

can you post a sample , so we can see the data structure and format please

you should be able to group by Hours
BUT you need the time in the "rows" section

[Amanda Wilso]

In the PivotTable, right-click any numeric or date and time field, and click Group.

In the Starting at and Ending at box, enter the time (as needed):

The smallest and largest number to group numeric fields.

The first and last date or time you want to group by.

The entry in the Ending at box should be larger or later than the entry in the Starting at box.

In the By box, do this:

For numeric fields, enter the number that represents the interval for each group.

For date or time fields, click one or more date or time periods for the groups.

You can click additional time periods to group by. For example, you can group by Months and Weeks. Group items by weeks first, making sure Days is the only time period selected. In the Number of days box, click 7, and then click Months.

[Palmetto]

Obviously a guess here since provided info is lacking . . . but

Sounds like you have set up the PT to count "items" but what you may need is to count the number of "accounts". Since one account may have many items ordered but each account is unique, you should be able to count the number of accounts that received an order (rather than how many items were ordered on the account). Remove "Items" from the Value field and drag in "Accounts".