Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 897
Default Pivot Table Percentages

If I drop 'Region' to the Row field and drop 'Utilization' on the
column field, I am able to see the percentages. Perhaps if you explain
what outcome you are looking for, and some sample data, someone might
be able to assist further.


HTH,
JP

On Feb 27, 3:23*pm, knowshowrosegrows
wrote:
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Percentages knowshowrosegrows Excel Discussion (Misc queries) 1 February 28th 08 01:26 AM
Applying Percentages to a Pivot Table Dan Excel Discussion (Misc queries) 0 March 16th 07 04:39 PM
Pivot Table Percentages Les Excel Discussion (Misc queries) 1 December 7th 06 09:39 PM
Calculating Percentages in Pivot Table GP Excel Discussion (Misc queries) 1 November 27th 06 10:16 PM
Pivot Table percentages cdb Excel Discussion (Misc queries) 2 March 22nd 05 09:09 PM


All times are GMT +1. The time now is 09:57 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"