4 Replies Latest reply on Dec 23, 2015 3:19 AM by Norbert Maijoor

    table calculation issue

    brant wu

      Hi guys:

           I have a view as Table1:

      Table1:

      product
      sales_volumerank
      p1100100%
      p220075%
      p330050%
      p440025%

      Metric rank is a table calculation for sales_volume ,rank = RANK(AVG([sales_volume]),'asc')/TOTAL(COUNTD([product])),

      Issue occurring when I do filter on product ,egg: I select product= "p4"  metric rank become to 100%

      table2:

      product
      sales_volumerank
      p4400100%

      It's possible that metric rank = 25% in Table2 when I select product = "p4"