Excel 2003 pivot table reports with JAWS 11

  • From: "L Fairman" <lfairman@xxxxxxxxxxx>
  • To: <jfw@xxxxxxxxxxxxx>
  • Date: Thu, 4 Feb 2010 19:48:39 -0800

Hi, 
 
I'm working in Vista, with JAWS 11 and Excel 2003.  
 
I'm trying to learn to use pivot tables.
 
I've been able to create reports by running the pivot table wizard with just
its default settings, and then using the pivot table toolbars to select
certain fields to put in the row, column and data areas.  
 
My problem is that when I put a field in the page area, as I understand it,
Excel should create a page of the report for each value that occurs in that
field. 
I am able to see the page withh a summary for all values, 
but am not able to navigate to any other pages where there should be data
for each discreet value in the page area field.
 
For instance, when I put Country in the page area, Salesperson in the row
area, and Amount in the data area, 
I get one page with all Salespersons and Amounts for all Countries together.
I can not find any other report pages, for instance showing just
Salespersons and Amounts for Country=USA,
or on another page just for Country=UK.
 
The Excel Help instructions say there should be an arrow next to Country on
the report, and that by clicking on that arrow, I should be able to move to
these other pages.
I'm not finding a menu/toolbar/keyboard equivalent for that arrow.
 
Has anyone worked with Excel 2003 pivot tables?
Specifically, has anyone found a way to view multiple pages on a pivot table
report?
 
Thanks in advance!
 
LuRetta
 

Other related posts: