7 Replies Latest reply on Jan 18, 2019 10:37 AM by Ravi Mistry

    How to do count distinct using LOD function?

    Tony Fahd

      So I am attaching a workbook where I have my location, Type of service and customer ID

       

      I like to get a count distinct of customer ID by Location only if the Type of service = A. any help is appreciated.

       

      I tried this but didn't work: {Fixed [Location]: If(Type='A' then CountD([Customer ID]) end}

       

      Thanks!

      Tony