Top N Filter

[andykbba]

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 many people in Australia work in one particular area of employment.

When i create a treemap it looks overly clustered as it is trying to fit all 19 industries of employments in.

I have a slicer which can be applied to produce the results for each postcode and the industries of employment vary depending on what is most popular in each area.

How do i apply a limitation/filter to only show the top 5 industries of employment in the tree map?

[Ashish_Mathur]

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.

[andykbba]

Hi thanks for this suggestion, 

When I do this it provides me with the following error. 

[Ashish_Mathur]

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.