Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am a pure novice at pivot tables.
I have data that is organized in the following fields Region (1 through 5) Agency Level Of Care Utilization Nov 07 (This is formatted as a percentage - Example 86%) Utilization Dec 07 (Also a percentage - Example 120%) Utilization Jan 08 (Also a percentage) The problem I have is that when I bring the data into the pivot table it shows up as a general number (Example - 1, 2 or 3). When I change the format in the pivot table to percentage, I get 100% or 200%. I get the same result if I format the original data to number (Example - .86 or 1.2) before I bring it to the pivot table and then try to reformat it after it is in the table. -- Thanks You all are teaching me so much |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Applying Percentages to a Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Percentages | Excel Discussion (Misc queries) | |||
Calculating Percentages in Pivot Table | Excel Discussion (Misc queries) | |||
How do I calculate percentages in a pivot table? | Excel Discussion (Misc queries) | |||
Pivot Table percentages | Excel Discussion (Misc queries) |