1 Reply Latest reply on Mar 22, 2016 11:21 AM by Andrew Connolly

    Top N where 1 worksheet uses the N from the measure in another

    Hope Stiles

      I have a dashboard with multiple worksheets on it.  I have one worksheet which is appropriately using a Top N Filter to show the top 10 individuals by case count.

       

      I also have a worksheet showing a bar chart.  I want the bar chart to show the same 10 individuals from the first worksheet.  The case count measure is not used in the bar chart.

       

      Attached is a workbook I borrowed from Ranking and filtering multiple work sheets in a dashboard. and then adjusted for my purpose.  Is there a way to get the Profit worksheet to show the same 10 individuals shown in the Orders worksheet?

       

      Thanks,

      Hope

        • 1. Re: Top N where 1 worksheet uses the N from the measure in another
          Andrew Connolly

          Hi Hope--

           

          You can create a set to solve this problem. Right click on customers in the dimensions pane, select Create > Set

           

          The screenshot below captures the rest of the settings. The key is selecting Order Quantity as the field, and the existing top N parameter.

           

          Capture.PNG

           

          Adding this set to the filter shelf will show the same top N customers on both pages of your dashboard.

           

          You may also want to sort both worksheets on the dashboard in the same order. To do this, drag the Order Quantity measure onto the rows shelf in the Profit worksheet. Click on the pill and change it to be discrete (blue).

           

          Then add a Rank table calc (click on the blue Order Quantity pill) that looks like this:

           

          Capture2.PNG

           

          Lastly, drag the discrete order quantity pill in front of the customer pill. You'll also want to hide this column, by clicking on the pill and deselecting "show header"