5 Replies Latest reply on Sep 25, 2018 9:15 AM by Mahfooj Khan

    Need help creating a Sheet

    Brad Shannon

      I'm trying to take the top 10 on the List and simply display those.  For anything greater than 10, I want to Sum those up and make one record out of it and tack it on to the bottom - below the first 10.  I think I need to create a Group or a Set.  Sorry.  I'm very new to Tableau.

       

      This is only my second project.

       

      I want to take this:

          

      RankCompanyProfitShipping Cost
      1CostCo$1.00$10.00
      2Anthem$2.00$9.00
      3Blue Cross$3.00$8.00
      4CVS$4.00$7.00
      5Walgreens$5.00$6.00
      6Target$6.00$5.00
      7Sams$7.00$4.00
      8Wal-Mart$8.00$3.00
      9Dierbergs$9.00$2.00
      10Schnucks$10.00$1.00
      11fdssg$88.00$11.00
      12dfdgdf$99.00$22.00
      13hfddfhf$99.00$33.00
      14gfddhgf$88.00$44.00
      15fdgw$77.00$55.00

       

      And make it look like this:

        

       

      RankCompanyProfitShipping Cost
      1CostCo$1.00$10.00
      2Anthem$2.00$9.00
      3Blue Cross$3.00$8.00
      4CVS$4.00$7.00
      5Walgreens$5.00$6.00
      6Target$6.00$5.00
      7Sams$7.00$4.00
      8Wal-Mart$8.00$3.00
      9Dierbergs$9.00$2.00
      10Schnucks$10.00$1.00
      All OthersAll Others$451.00$165.00

       

       

      Additionally, it would be nice if I could change the 10 to some other number.

       

        Any advice, any help would be greatly appreciated.

       

      Thanks.