Display only records where a dimension entry comes up more than once

[s33pie008]

Hi everyone

I'm having trouble with a straight table, where I have to display only records where a certain dimension's value comes up more than once.

Lets say I have a dimension called ID, and then Username as an additional dimension. The end result must be that the chart must only show entries where the ID column is not distinct, i.e. if ID number 1234 is associated with more than one Username, show those entries, otherwise don't.

Any help will be appreciated.

[sunny_talwar]

What is your expression that you use? Assuming your expression is Sum(Measure), change it to this

Sum({<ID = {"=Count(DISTINCT UserName) > 1"}>}Measure)

[s33pie008]

Thank you for your quick feedback.

Basically the straight table must act like a tablebox, where I only display Customer information where an ID is associated with more than 1 customer

[sunny_talwar]

So, may be try this

Dimensions

ID
Customer

Expression

Sum({<ID = {"=Count(DISTINCT Customer) > 1"}>}Measure)

and on the presentation tab of the chart properties hide the expression so that you only see two dimensions

[dplr-rn]

Maybe try
Customer as dimension
Expression
Only({<ID = {"=Count(DISTINCT Customer) > 1"}>}ID)