3 Replies Latest reply: Sep 15, 2014 9:37 AM by Irving Bos RSS

    use CUST_ID as dimension, but show CUST NAME?

      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.