1 Reply Latest reply on May 1, 2018 11:23 PM by kumar bharat

    Calculating measure according to top n accounts, accounts with segments and all accounts

    avi.b.0

      Hi,

       

      I want to create a table that contains the following fields:

      top 10 accounts
      top 20 accounts
      all accounts
      accounts with segment
      measure 1 (ex- count(sales))10%11.5%
      measure 2 5%3%
      measure 312%20%

       

      The top n accounts, should be calculated according to sum(sales)

      and I want the whole table to be affected be the date the user select

       

      I was able to create on tableau top n account with the help of the following post: Top 10 or 2nd top10 Values in Calculated field

      but I don't want to present my accounts in the table

       

      Thanks!!!!