Dynamic Field labeling in Table or pivot
Is there a way to change the field title for a variable in either a pivot or table based on a specific value. More specifically-- we have variables desc1, desc2, desc3..... For each customer what desc1, desc2, desc3 contains or is called by them varies...so for customer a desc1 is region, for customer B desc1 is state and customer C desc1 is county. We have a look up table that contains the detail by customer of what desc1, desc2, desc3 is. How can I dynamically name the variable in a pivot or table widget based on the value in the lookup table? Im wondering if this can be done in either js or even sql as part of a custom table in the elasticube....
Also to note we are already using the metadata translator for multilingual support so using that plugin is probably a bad idea and creates way too much complexity.