Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table grouping issues | Excel Discussion (Misc queries) | |||
Pivot Table Count | Excel Discussion (Misc queries) | |||
Count within pivot table | Excel Worksheet Functions | |||
Pivot table range issues from report writer download | Excel Discussion (Misc queries) | |||
Count in Pivot Table | Excel Worksheet Functions |