Pivot Table did not consolidate data

Copper Contributor

I made a pivot table with customers and products and one of the customers were not consolidated shown here:


The data is from this table:


Any help would be appreciated, Thanks!

1 Reply

@GreenSpleen420 Not visible from the screenshot but I suspect that one of them has one or more training spaces. "aaa Hospital" is not the same as "aaa Hospital  ". Check and correct the source data.