Pivot Table displaying incorrect data

%3CLINGO-SUB%20id%3D%22lingo-sub-3181027%22%20slang%3D%22en-US%22%3EPivot%20Table%20displaying%20incorrect%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3181027%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%20%26nbsp%3BI%20am%20trying%20to%20create%20a%20pivot%20table%20to%20create%20a%20histogram%20comparison%20for%20my%20data.%20%26nbsp%3BWhen%20I%20create%20the%20pivot%20table%2C%20the%20column%20headers%20populate%20accurately%2C%20however%20the%20data%20within%20is%20not%20completely%20correct.%20%26nbsp%3BOnly%20two%20columns%20are%20accurate%2C%20while%20the%20other%204%20are%20displaying%20data%20from%20one%20set%20of%20data.%20%26nbsp%3BIn%20my%20screenshot%2C%20Count%20of%20Cycle%201%20and%20Count%20of%20Cycle%205%20are%20correct%2C%20but%20Cycles%203%2C%207%2C%209%2C%20and%2010%20are%20displaying%20data%20for%20Cycle%201%20instead%20of%20their%20own%20information.%20How%20do%20I%20fix%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202022-02-17%20at%2012.18.50%20PM.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349191i63C733AA3781949F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202022-02-17%20at%2012.18.50%20PM.png%22%20alt%3D%22Screen%20Shot%202022-02-17%20at%2012.18.50%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202022-02-17%20at%2012.19.57%20PM.png%22%20style%3D%22width%3A%20458px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349193i1AD482F9E57BC95B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202022-02-17%20at%2012.19.57%20PM.png%22%20alt%3D%22Screen%20Shot%202022-02-17%20at%2012.19.57%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3181027%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3182414%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20displaying%20incorrect%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3182414%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1310631%22%20target%3D%22_blank%22%3E%40laurgal%3C%2FA%3E%26nbsp%3BYou%20don't%20show%20the%20underlying%20data%2C%20but%20I%20suspect%20that%20all%20cells%20with%20cycle%20values%20contain%20something%20and%20thus%20get%20counted.%20For%20instance%2C%20if%20these%20values%20are%20populated%20by%20a%20formula%20to%20contain%20%3CSTRONG%3E%3CFONT%20color%3D%22%23DF0000%22%3E%22%22%3C%2FFONT%3E%3C%2FSTRONG%3E%26nbsp%3Bto%20shows%20as%20a%20blank%2C%20these%20cells%20will%20still%20be%20counted%20in%20a%20pivot%20table.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello.  I am trying to create a pivot table to create a histogram comparison for my data.  When I create the pivot table, the column headers populate accurately, however the data within is not completely correct.  Only two columns are accurate, while the other 4 are displaying data from one set of data.  In my screenshot, Count of Cycle 1 and Count of Cycle 5 are correct, but Cycles 3, 7, 9, and 10 are displaying data for Cycle 1 instead of their own information. How do I fix this?

 

Screen Shot 2022-02-17 at 12.18.50 PM.png

Screen Shot 2022-02-17 at 12.19.57 PM.png

1 Reply

@laurgal You don't show the underlying data, but I suspect that all cells with cycle values contain something and thus get counted. For instance, if these values are populated by a formula to contain "" to shows as a blank, these cells will still be counted in a pivot table.