This content has been marked as final. Show 3 replies
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.