Pivot Table

Hi Nestor

When placing data in a pivot table if one of your fields contains dates and you place it in the row section (for example) then as a default the system will group it by days.

This shows the sales per day

To view the data as Sales per Month, Quarter, etc then you do the following:

1. Right click one of the dates in the range

2. On the menu click Group

3. The Grouping dialog box apprears showing:
- The Start and End dates (Which can be changed and deselected
- A list of group types which can be selected alone or in groups

eg Group by Months OR Group by Quarters and Months

4. Click OK

The table should group according to your selection

Regards

Carlos