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 |
Pivot Table Percentages
Use Average instead of Sum.
If my layout isn't close to yours, upload your spreadsheet. http://www.freefilehosting.net/download/3cjj0 |
All times are GMT +1. The time now is 11:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com