Do nut chart-Distinct count By dimension and different count by sorting

Hi All,

I have created a do nut chart for distinct authoriztion number.

I have to count distinct authorization number based on portal sorted by Approved Date.

For Example in attached worksheet,

1.I have 4 distinct authorization number for  portal but human touched and 2 for completed by portal and 3 for fully manual. but this is calculated at Line ID level.

What business wants is,

1. Sort by approved Date .

2. if first approved date has Fully manual, then consider that distinct AuthorizationNumber  as Fully manual and do not count it in other category(ex:A20170800000000).

3. if first approved date has portal but human touched , then consider that distinct  AuthorizationNumber as portal but human touched and do not count it in other category(ex:A20000000032411).

4. if any authorization number  has completed By portal  and  portal but human touched then calculate this Authorization number as distinct for portal but human touched.(ex:A20170000052073)

5.if any authorization number  has completed By portal  and  Human touched then calculate this Authorization number as distinct for portal but human touched.(Ex: A20170800000012).

6 If all are same portal, then distinct is calculated /portal(ex: A20880000052073 is distinct in completed by portal and A20181019060000 in fully manual).

So the expected distinct count is,

1. Portal But Human touched: 5 (A20000000032411,A20170000000000,A20170000052073,A20170800000012)

2.Fully Manual: 3(A20170800000000,A20181019060000,A20170800005555)

3.Completed By portal:1(A20880000052073)

Is this doable?