mark duplicates?

[#1]

hi all,

i want to color in my chart dimension that are duplicates, for exp:

dimensions:

sales rep      USERS

eric                 A

sam                B

haya               C

i want to mark in red color users that have two "sales rep":

sales rep          USERS

eric                    A

sam                   A

how can i do it?

thanks

[swuehl]

Use a background color attribute expression like

=if(count(total<USERS> distinct [sales rep])>1,lightred())

for your USERS dimension (open the attributes by clicking on the plus sign next to the dimension on dimension tab).

Hope this helps,

Stefan

[#3]

thank you, this is good but he color only if i open two that the same he dont tell me if only one user is open("-" sign)

do you know how to make buton that gives me al the duplicates?

thank you for the answer.

[swuehl · Accepted solution]

If you want a list of USERS with duplicates, you could also use a list box, with a field expression (select <EXPRESSION> from the field drop down on general tab of list box properties) like

=aggr(if(count(DISTINCT [sales rep])>1, USERS), USERS)

I haven't fully understood your last answer, are you using a pivot or a straight table? With what dimensions in what order? You can force a pivot to fully expanded on presentation tab. Or use a straight table instead.

You should use at least the two dimensions USERS and sales rep.

Hope this helps,

Stefan

[#5]

thank you very much,its work.