Pivot Table Percentages
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 |
All times are GMT +1. The time now is 06:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com