Pivot Table displaying incorrect data

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.