pivot table defaults to count instead how to count values in a pivot table count distinct values in excel pivot pivot table defaults to sum or count change count to sum in excel pivot pivot table basic count exceljet pivottable value fields change count to sum in excel pivot excel pivot table calculated field excel pivot tables text instead of pivot table defaults to count instead sum values in a pivottable microsoft pivot table count with percene excel pivot tables summarizing values excel pivot tables count unique items change count to sum in excel pivot how to count unique values in pivot table pivot table with text in values area how to count unique values in pivot table pivot table two columns of text show show text in a pivot table values area pivot table value field settings you pivot table with text in values area how to use pivot table field settings customizing a pivot table microsoft excel pivot table summary functions sum errors in pivot table totals how to get a count via pivot table in count distinct values in excel pivot how to make and use pivot table in excel how to count unique values in pivot table pivot table count unique step by step change count to sum in excel pivot change the value field settings pivot table two way count exceljet how to use pivot tables excel s most how to create pandas pivot table count excel pivot table ms excel pivot table deleted items pivot table filter how to filter data advanced pivot table tips and tricks use excel pivottables to quickly excel pivot tables text instead of pivot tables how to change the default