1 Reply Latest reply: Jul 6, 2017 12:42 PM by Sunny Talwar RSS

    Show top 80% of spend

    Gareth Lloyd

      Good morning guys


      I'm after some more help if possible please.

       

      SupplierYTD Spend (£)
      Supplier C55082544.02
      Supplier N7080656.50
      Supplier P6481116.09
      Supplier L8312827.59
      Supplier D26443274.72
      Supplier F16021954.61

       

      In the table above, I am looking for an expression that will only show the top 80% spends of the cumulative total in the spend table listed above. Carrying it out as a Dimension limit throws back all kinds of weird and wonderful things.

       

      I appreciate your help,

      Gareth