Hide Row in Chart base on expression column

[#1]

I am trying to create  a pivot table with 1 dimension (A) and 1 expression (Count of A). I want to result set shows expression result > 1 only.

Example:

Data:

Row 1: A = 123

Row 2: A = 123

Row 3: A = 455

Row 4: A = 345

Row 5: A = 345

Row 6: A = 345

Row 7: A = 111

I want the resulting pivot table shows:

A       Count of A

123         2

345         3

Try using count in dimension but doesn't work. Any other options/suggestion?

[Anonymous]

No need to do the count as a dimension.

Set the field with A as a dimension, then Count(Fieldname) as expression.

Go to the tab called dimension limits and activate the limits with the checkbox and set "Show only values that are greater than", 1, and "Exact amount".

[#3]

Thanks Johannes. It works.