Help With Pivots

[bdaoust]

I have the following data:

PolicyNumber ReceivedTransDate TimeToIssue 0-15 16-30 31-45 45+
45454544 1/4/2006 0 1 0 0 0
67676766 1/4/2006 0 1 0 0 0
65656565 1/4/2006 1 1 0 0 0
65654544 1/4/2006 77 0 0 0 1
76766565 1/4/2006 75 0 0 0 1
65656665 1/4/2006 91 0 0 0 1
65656545 1/4/2006 54 0 0 0 1

I want to create a pivot table that looks like this

0-15 16-30 31-45 45+
Jan 3 0 0 3


As you can see from the raw data, I have calculated the Time to Issue
date and place that figure into different buckets.

Now I want to rollup the data - my month - to show counts in all
buckets.

Can anyone help?

Thanks,
Brian

 

[Debra Dalgleish]

In the pivot table, right-click on the Date field button, and choose
Group and Show Detail > Group
In the 'By' list, choose Months and Years
Click OK