I am trying to find out server utilization at a directory level. Total space is 100 GB. It is allocated to two levels equally and the rest of the sub-directories share the allocated space based on the usage. I got the directories usage how much space is used. But when I sum it up at the last level it won't add up to 100GB because for some directories, users haven't created sub-folders. So I need to go back and add it to know how much is used.
Input file is attached. Raw data is residing from column A to Column C and the output which i am looking for is available from column F- Column H.
It will be great if some one assit me.