2 Replies Latest reply on Nov 13, 2018 7:21 AM by Andrew Benito

    Filtering:Top N and All option with calculated fields

    Andrew Benito

      Hello,

      I'm trying to create a  customer filter that has options to filter by:

      Top 10 by % of Total Sales

      Top 10 by % of Total Growth

       

      % of Total Sales and % of Total Growth are both calculated fields.

       

      I was trying to follow Joshua Milligan's post on this thread: TOP N and All option, but when I go to create the sets, the measures are not available to select from. I am aware that this has to do with Tableau's order of operations, but I am not sure how to work around the issue. Any ideas?

       

      Thanks!

      T problem.jpg