HELP! Customer count issues... Pivot Table disaster
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 |
HELP! Customer count issues... Pivot Table disaster
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 HoganD87 wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 11:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com