excel - Show all unique values using Pivot Table

Question

asked Jan 31, 2022 in Technique[技术] by 深蓝 (71.8m points)

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

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

119 views

1 Answer

深蓝 · Answer 1 · 2022-01-31T07:13:45+0000

answered Jan 31, 2022 by 深蓝 (71.8m points)

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

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…