Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try using calculated dimension, like:
=Dual(FirstName, CUST_ID)
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)
works! thanks