HELP! Customer count issues... Pivot Table disaster

H

HoganD87

EXTREMELY IMPORTANT!

My Pivot Table

example.

"SPREADSHEET"
DATE JOB CONTRACTOR
1/1 1 A

1/2 2 B \
A > One Cell
C /

1/3 3 C

when I graph how many time each contractor is used its...

"MY UNWANTED GRAPH"
contractor A.... 1 time
contractor B [] A [] C... 1 time
contractor C... 1 time


How, if at all possible can I make it...

"WHAT I WANT"
contractor A... 2 times
contractor B... 1 time
contractor C... 2 times

And whats with the boxes in

"contractor B [] A [] C... 1 time"

notes:
=SUM(IF(ISNUMBER(H3:H43),1,0)) Thats my formula for my pivot table
 
D

Debra Dalgleish

In your data, you've entered the contractor for job 2 on 1/2 as
B(Alt-Enter)A(Alt-Enter)C
When shown in a cell with Wrap Text turned on, the contractors show on
separate lines in the cell
If Wrap Text is off, you see little boxes instead.

If you want these counted separately, you should enter each contractor's
information on a separate row in the data. For example, instead of:

Date Job Contractor
1/2 2 B(Alt-Enter)A(Alt-Enter)C

enter:
Date Job Contractor
1/2 2 B
1/2 2 A
1/2 2 C

EXTREMELY IMPORTANT!

My Pivot Table

example.

"SPREADSHEET"
DATE JOB CONTRACTOR
1/1 1 A

1/2 2 B \
A > One Cell
C /

1/3 3 C

when I graph how many time each contractor is used its...

"MY UNWANTED GRAPH"
contractor A.... 1 time
contractor B [] A [] C... 1 time
contractor C... 1 time


How, if at all possible can I make it...

"WHAT I WANT"
contractor A... 2 times
contractor B... 1 time
contractor C... 2 times

And whats with the boxes in

"contractor B [] A [] C... 1 time"

notes:
=SUM(IF(ISNUMBER(H3:H43),1,0)) Thats my formula for my pivot table
Click to expand...
 
Top