Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables in Office 2007
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables in Office 2007
Have a look at this site:
http://www.contextures.com/xlPivot02.html best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "DOUG ECKERT" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables in Office 2007
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 Liengme" wrote: Have a look at this site: http://www.contextures.com/xlPivot02.html best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "DOUG ECKERT" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables in Office 2007
"DOUG ECKERT" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables - Hide Zero Amount Rows In Office 2007 | Excel Discussion (Misc queries) | |||
2007 Pivot Tables | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Office 2007 Trace Precedents + Tables | Excel Discussion (Misc queries) | |||
Pivot Tables keep corrupting -- Office 12 beta | Excel Discussion (Misc queries) |