Compare average with Top n regions

Question

How to compare average profit of all regions with top n regions using filter?

Answer 1

Hi Akshay,

1. Create a calculated field to find the avg of all regions using fixed lod.

2. Now drop region in filter shelf and select Top and enter N with max sales.

3. Drag and drop avg(profit) in sheet and regions in the sheet.

4. Now add the calculated field in step1 into the sheet or create a reference line against all regions using a bar chart.

Hope it helps you.