Pivot Table Percentages

K

knowshowrosegrows

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.
 
J

JP

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table & Date orders 2
Pivot Table Percentage of Sub-Total 7
Pivot Table percentages 1
Pivot Tables 3
Pivot Table Grouping 1
Excel Pivot Table How to Sort data as Percent of Row 12
% of subtotal in pivot tables 1
Excel 2007 - Pivot Table and Calculated fields? 1

Top