3 Replies Latest reply on Mar 14, 2018 11:04 AM by Andrew Bickert

    Top 5 using one dimension and multiple measures

    Morgan Lindsey

      Hi I'm trying to show the top 5 company codes using the same company code filter (applies to all worksheets) but with different measures/ y axis.


      I tried editing the company code dimension filter so that it shows Top 5 by field but the field changes with each graph. I only bring in the filter from one of the graphs and "apply to all" since it should affect all graphs. Therefore, I cannot apply the filter to all worksheets on the dashboard or else Current AR and Overdue AR would show the top 5 by "Total AR" and not "Current AR" or "Overdue AR".


      I only need this filter for the bottom graphs. Anyone know of a way around this issue?