Pivot Tables in Office 2007

  • Thread starter Thread starter DOUG ECKERT
  • Start date Start date
D

DOUG ECKERT

Did something change in the way pivot tables are constructed in Office 2007,
in addition to the obvious improvement in the onscreen interface? I am
having a devil of a time pulling out calculations which make sense.
 
Bernard: That is a very good resource, thank you. However, I am trying to
use a pivot table to count YES and NO responses in a spreadsheet and to show
the "YES" responses as a percent of the total responses. It works to a
limited degree, but I am generating an extra row with "YES" or "NO" and it is
messy. 'Any sugggestions?

DOUG
 
:

Bernard: Is it fair to say that each Pivot Table can only answer one
question? (I wanted to rate multiple medical providers against multiple
coding criteria, i.e., how well they documented the care they provided).
But, in a pivot table, I could measure one provider against multiple criteria
- or, one criteria against multiple providers. But, I could not rate
multiple providers against multiple criteria, could I? IF THAT IS TRUE, then
would I not be better off constructing a stoplight chart and grading their
score on a graduated scale - like in elementary school?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Pivot Tables compatible with 2003 3
create calculated field for age in pivot tables 4
Average of Subtotals in Pivot Table 0
Pivot Tables: Excel 2003 vs Excel 2007 2
pivot table 2
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pre-configuring Pivot table "views" 4
show pages on a pivot in 2007 1

Back
Top