Pivot Table Values

%3CLINGO-SUB%20id%3D%22lingo-sub-2772271%22%20slang%3D%22en-US%22%3EPivot%20Table%20Values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2772271%22%20slang%3D%22en-US%22%3EHello.%20New%20to%20working%20with%20Pivot%20Tables%20and%20running%20into%20an%20issue%20when%20trying%20to%20add%20two%20different%20fields%20from%20my%20source%20data%20to%20the%20values%20section.%3CBR%20%2F%3EI%20am%20creating%20a%20report%20to%20highlight%20the%20number%20of%20projects%20each%20month%20that%20are%20added%20to%20and%20completed%20for%20my%20teams%20project%20queue.%20Both%20columns%20in%20the%20source%20data%20are%20dates%20(mm%2Fdd%2Fyyyy).%20One%20column%20is%20Added%20On%20and%20the%20other%20is%20Completed%20On.%20When%20I%20drag%20both%20fields%20into%20the%20values%20section%20of%20the%20pivot%20table%2C%20I%20set%20both%20as%20%E2%80%9Ccount%20of%E2%80%9D%20by%20month%2C%20and%20it%20returns%20the%20same%20value%20for%20both%20columns.%20So%20if%20I%20added%205%20projects%20in%20March%20and%203%20projects%20in%20April%2C%20the%20pivot%20table%20shows%20me%20that%20I%20completed%205%20projects%20in%20March%20and%203%20in%20April.%20If%20I%20do%20two%20separate%20pivot%20tables%2C%20I%20can%20get%20distinct%20counts%20for%20each%20month%2C%20but%20I%20ideally%20would%20like%20them%20in%20a%20single%20pivot%20table.%3CBR%20%2F%3E%3CBR%20%2F%3ENot%20sure%20if%20this%20is%20relevant%2C%20but%20some%20of%20the%20fields%20in%20the%20Completed%20On%20column%20are%20text%20and%20marked%20as%20%E2%80%9CNot%20Completed%E2%80%9D.%20When%20I%20do%20the%20two%20separate%20charts%20I%20can%20filter%20off%20the%20%E2%80%9CNot%20Completed%E2%80%9D%20items%20and%20get%20a%20count%20of%20the%20projects%20that%20are%20complete.%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20this%20question%20makes%20sense.%20Thanks.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2772271%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2774661%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20Values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2774661%22%20slang%3D%22en-US%22%3ECan%20you%20upload%20a%20workbook%20which%20contains%20both%20a%20sample%20of%20your%20data%20and%20a%20sample%20of%20the%20expected%20output%3F%20Please%20make%20sure%20no%20sensitive%20data%20is%20included!%3C%2FLINGO-BODY%3E
New Contributor
Hello. New to working with Pivot Tables and running into an issue when trying to add two different fields from my source data to the values section.
I am creating a report to highlight the number of projects each month that are added to and completed for my teams project queue. Both columns in the source data are dates (mm/dd/yyyy). One column is Added On and the other is Completed On. When I drag both fields into the values section of the pivot table, I set both as “count of” by month, and it returns the same value for both columns. So if I added 5 projects in March and 3 projects in April, the pivot table shows me that I completed 5 projects in March and 3 in April. If I do two separate pivot tables, I can get distinct counts for each month, but I ideally would like them in a single pivot table.

Not sure if this is relevant, but some of the fields in the Completed On column are text and marked as “Not Completed”. When I do the two separate charts I can filter off the “Not Completed” items and get a count of the projects that are complete.

Hope this question makes sense. Thanks.
2 Replies
Can you upload a workbook which contains both a sample of your data and a sample of the expected output? Please make sure no sensitive data is included!
Hi Jan. Thank you for the offer to help. I actually kept googling last night and found an answer. I needed to change the field options from Count to Count Numbers. Once I did that for both values it solved the issue.
Thanks again. I appreciate the reply.