G
Guest
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
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