Forum Discussion
Top N Filter
Hi all, I have some general Australian Bureau of Statistics Data. Essentially I have the location of a place in Australia (in one column) And 19 other columns which show how m...
Hi,
In the Query Editor, select the Location column, right click and select "Unpivot Other Columns". Click on Close and Apply. Work with this transformed dataset.
Hi thanks for this suggestion,
When I do this it provides me with the following error.
On unpivoting, entries in the location column are repeating causing the Many to One relationship to fail. Create a Location Dim Table which should only have all the unique locations. Create Many to One relationships to this Location dim table.