pivot table basic count exceljet count rows in group with pivot table in count distinct values in excel pivot pivot table count by year exceljet excel pivot table calculated field create excel pivot table calculated how to count unique values in pivot table how to count unique values in pivot table pivot table defaults to count instead pivot table count with percene count distinct values in excel pivot how to count unique values in pivot table distinct count with pivot tables