I have a report that is un-pivoted in excel and i later pivot a selection of columns in Tableau. However, I am noticing every week when the report is refreshed the columns I pivoted previously populate again. I am unable to add the columns again to the pivot as the option is not available.
Has anyone else faced this issue/concern when new data is added that your pivot name and values do not match up anymore? What was your solution and work around?