5 Replies Latest reply on Feb 15, 2016 6:32 AM by Adam Crahen

    Value of top 5 customer sales in latest quarter

    Lloyd Buss



      I have created a worksheet showing the sales in the latest quarter as a discrete pill and a spark line trend to go with it. What I would like to also do is create another discrete pill showing the top 5 customers sales. Latest quarter sales is expressed as - WINDOW_SUM(IF Last()=0 then SUM([Sales]) End)


      Latest quarter - £280,594

      Top 5 within quarter should be £44,283


      Can anybody help?