10 Replies Latest reply on Jan 10, 2017 8:41 AM by Brian Connelly

    count data based condition with zero in case no record

    Prakash Tiwari

      I have a requirement to show number of units for a particular date each approval status and their value but it should zero if there is no record for approval status. I have attached sheet with record and date selected is 18/12/2016 which has only two approval status. Also I am looking color for circle as fixed red, orange and green. Is it possible?

       

      Thanks

      Prakash