2 Replies Latest reply on Apr 20, 2018 6:50 AM by susheela.hegde

    Distinct Count For Specific Dimension

    susheela.hegde

      Hi All,

       

      I have to calculate the Distinct Count Of Auth Id across  Status.

      In attached Workbook, I have 3 Status(Portal,Partial Portal,Human Touched) and I have to calculate distinct count of Auth Id's for these status.

      For example, Auth1 has  2  Service Line ID's  and with status both Portal and Partial Portal. This Auth will be distinct for Partial Portal because one of the Service Line is Partial Portal.

      How ever, This is Counting distinct Even for Portal status. How can I get this Auth ID  distinct only for  Partial Portal and not for Portal?

      Similarly, for Auth 2, both the Service Line ID's are Portal and this will be calculated as distinct Auth ID for Portal. 

      I have attached the workbook and would appreciate any help.