Show all unique values using Pivot Table

2019-09-20 08:24发布

问题:

Is it possible to use Pivot Table in order to return all distinct/Unique Values?

I know that it is possible to count all unqiue values but I want to return/show all unique value

回答1:

Of course, just drag the field you need the unique data from to the row area of the PT.