use CUST_ID as dimension, but show CUST NAME?

[#1]

I think I am missing something obvious. I want to show top ten customers, measured by sales. If is use CUST_NAME as the dimension, it will lump all the 'SMITH's together, so I use CUST_ID which is unique. That works, but I want to show CUST_NAME on the actual chart, not CUST_ID. I have concatenated last name and ID together to use as dimension, which works, but looks hacky. I want just the name (actually first and last, but I can sort that out). What am i overlooking? thanks.

[tresesco · Accepted solution]

Try using calculated dimension, like:

=Dual(FirstName, CUST_ID)

[MK_QSL]

Straight Table

Dimension

Calculated Dimension

IF(Aggr(Rank(SUM(Sales),4),CUST_NAME)<=10,CUST_NAME)

Tick Suppress When Value is NULL

Expression

SUM(Sales)

[#4]

works!  thanks