6 Replies Latest reply on Jun 19, 2018 8:02 AM by Zhouyi Zhang

    How can i use a Fixed LOD to remove multiples per ID?

    waqar ahmad

      Hi everyone,


      trying to get one row per record in this workbook to no avail. In the screenshot example, I have no value for "work type" and so I would like my row to just show The ID, Label "Percent Complete" and the Percent complete value.

      I'd like to get rid of Work Type. I've attached my workbook for help but this is as far as I could get with this.


      I fixed it on the ID and the label and got the Min customfield value, but I'm not sure why I'm seeing multiples for the "Percent Complete" Column.


      Can someone help?


      Greatly appreciated,