Decimals instead of whole numbers acroos pivot

F

Frenchie

Hi,
I have data with decimals. I need them to be whole numbers in a pivot table
and then be the columns.
Currently I have formatted the original data to be 1instead of 0.7 and 0.8
but am getting 4 column with 1 in them and the count associated with it.
Any idea how I get just one column with all 0.1, .2etc in the correct field.
 
L

Luke M

In your PivotTable, double-click on the data field button that controls the
numbers your interested in. Change setting from Count to Sum. Now click on
the number button, and change the format to number with 1 or 2 decimals.
 

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

Excel does not accept text format! 0
Dealing with a Pivot Table (when I don't want to) 0
Mail Merge - displaying a conditional number of decimals 5
List all tables, including document structure 0
Paragraph numbering in Word 1
Pivot Table Data Aggregation 0
Pivot Table Counting Text Data 0
Pivot Table Counting Text Issue 0

Top