I have a csv file that dumps from our financial system. The information is sorted by hierarchy and under each hierarchy code a cost code. The cost code belongs to a particular expense group. I need to be able to determine the total for each expense group, by hierarchy for a 12 month period.
Assume my data is as follows:
Account Code Expense Group Amount
HIERONE
1234567890 E3 100
9876543219 E1 200
2587945632 E2 300
1258795463 E1 400
1258796532 E2 500
1254899720 E3 600
1258786931 E4 700
HIERTWO
1231657986 E4 100
1236498710 E3 200
1235789654 E2 300
1235649874 E3 400
1236798745 E3 500
So for Hierarchy one (HIERONE), I want to be able to pull out a total of $600 for expense group E1, $800 for E2 and so on. And then do the same for the next hierarchy, and the next.
Help?
Assume my data is as follows:
Account Code Expense Group Amount
HIERONE
1234567890 E3 100
9876543219 E1 200
2587945632 E2 300
1258795463 E1 400
1258796532 E2 500
1254899720 E3 600
1258786931 E4 700
HIERTWO
1231657986 E4 100
1236498710 E3 200
1235789654 E2 300
1235649874 E3 400
1236798745 E3 500
So for Hierarchy one (HIERONE), I want to be able to pull out a total of $600 for expense group E1, $800 for E2 and so on. And then do the same for the next hierarchy, and the next.
Help?