1 2 Previous Next 22 Replies Latest reply on Jun 4, 2015 11:47 AM by Vamsi Garapati

    How to get Top N and Others for cross tab?

    Marcos Rodriguez

      I am new to Tableau but have used Crystal Reports for years.
      I am trying to get the simplest solution to getting Top 25 ( for example) and then Others.



      I thought it was as easy as using the Filter Function? Then Tab = Top then Select Field "Total Travel Spend" then choose 25 then get top 25 with rest as other?  This is very easy in crystal but I have tried via forums in Tableau and am lost as to what to do.ra


      1 John  5
      2 Bob 5
      3 Sally 5

      4 Susie 5

      5 Carol 5
      6 Ed  5

      etc to 25 Mary5
      Other 65

      Total 100

        1 2 Previous Next