could you make 3 more fields in your data.

Then categorize your data there. Then use them in the page field instead of the
individual value?

Shashi Bhosale wrote:

I have a three choices on the page of the pivot table.
1. Site
2. Dept
3. Accounts

I limited to choose only one option from a choice. I want to select a range
instaed.
Ex. account range - 100010 - 100020; Dept : 1212 - 4444; Site : 001 - 999.

Is there a way to achieive this?

Thanks in advance, Shashi.

--

Dave Peterson