Hello all - I need another help. I need to calculate total of the dataset and then percentage of total only for a dataset with over 100 clients together. Please help.
Input:
Client | Client Number | Data | Data1 | Data2 |
A | 1 | Cash | 3 | 50 |
A | 1 | Accounts Payable | 4 | 110 |
A | 1 | Accounts Receivable | 5 | 250 |
A | 1 | Inventory & COGS | 6 | 200 |
B | 2 | Cash | 7 | 150 |
B | 2 | Accounts Payable | 8 | 85 |
B | 2 | Accounts Receivable | 9 | 90 |
B | 2 | Inventory & COGS | 10 | 110 |
Output:
Client | Client Number | Data | Data1 | Data2 | Ratio |
A | 1 | Cash | 3 | 50 | |
A | 1 | Accounts Payable | 4 | 110 | |
A | 1 | Accounts Receivable | 5 | 250 | |
A | 1 | Inventory & COGS | 6 | 200 | |
A | 1 | Total | 18 | 610 | 0.029508197 |
B | 2 | Cash | 7 | 150 | |
B | 2 | Accounts Payable | 8 | 85 | |
B | 2 | Accounts Receivable | 9 | 90 | |
B | 2 | Inventory & COGS | 10 | 110 | |
B | 2 | Total | 70 | 1655 | 0.042296073 |