Pivot table to show Count for unique value - Microsoft Community
When I perform a pivot as "Department in Row label" and count of "PO number in Value" it shows as 3 PO number for government and 2 PO number for School but actually it is 2 PO number for Government and 1 PO number for school due to PO line number it shows like it, I cannot remove PO line number, anyother alternate way to shows only unique value . . .
more
|