1 Reply Latest reply on Mar 27, 2013 6:26 AM by Amol Gokhale

    Not able to find solution for creating calculated field which includes TOP N

    Amol Gokhale

      Hi,

       

      I have a specific scenario where in I need to create a calculated field which will be division of "sum of sales for all countries(for all products)" and "sum of sales of for top 30 products by sales for all countries". So what I mean here is "sum for top 30 products/sum for all products". I am not able to find a solution for this.

       

      I cannot apply filter since on product since it will affect the whole sheet.

       

      Is it possible to achieve this in tableau? I have attached data set for reference.

       

      Thanks,

      Amol