I have a single large excel spreadsheet/table with information about sales, products, and country. I want to break this table into separate tables by Referencing certain columns (Country Name/Product Name, etc) and then adding an index column (Country Index/ Product Index, etc) in the Referenced table so that I can use the indices (1,2,3) in the facts table and get rid of the text columns (Country Name - Germany, Mexico, Product Name - xyz). However, the moment I make any adjustments to the column (replace values with indices) in the original table, the same adjustments apply to the column in the referenced table and therefore I am unable to use that column effectively (by replacing the text values with indices) let alone get rid of it. As of now, I have only hidden these columns from the Report View and as a result the original large spreadsheet remains. Is there any other way I can make the original table more lean without affecting the tables that have already been split out of it through referencing columns? Is there any other approach I can take to split the original table? Thanks in advance!
