0 Replies Latest reply: Aug 24, 2018 8:05 AM by shivesh singh RSS

    Need a table based on below conditions

    shivesh singh

      Hi Guys

       

      Need your help here. Please check below table.

          

      Sr. NoMonthDMU NamesLocationABCDE
      1AUGKeralaIndia10232235
      2AUGDelhiIndia124525567
      3AUGNoidaIndia2653
      4AUGLucknowIndia643
      5AUGDelhiIndia1367254
      6AUGDelhiIndia6823
      7AUGLucknowIndia146323
      8AUGKeralaIndia177233598
      9AUGNoidaIndia1933254
      10AUGKeralaIndia203439

       

       

      Through this table, i need below table

       

       

      ProductAugBenchmark
      A230
      B330
      C130
      D230
      E3

      30

       

       

      Here bench mark should be editable and dynamic and logic for getting the values below Month(AUG) is

      lets take eg for A, so here '2' signifies the count of DMUs whose sum(A) is greater than benchmark.(Kerala and Noida)

       

      Please help, and i don't have license as of now, so kindly help with the expressions and script as well.