Finding averages based on selected ID (client)
The data I am working is at an asset level (example below) and I would like to find the average of all client ages accurately when looking at any segment of asset. Client Account Asset Age Client 1 Acc 1 Sec1 50 Client 1 Acc 1 Sec2 50 Client 1 Acc 2 Sec3 50 Client 1 Acc 2 Sec4 50 Client 1 Acc 2 Sec1 50 Client 1 Acc 2 Sec2…