Could you please get me the proportion by id and by loan purpose for below sample data
Data:
Id Loan
94 Expansion
94 Working Capital
94 Expansion
95 Working Capital
95 Working Capital
95 Inventory
99 Working Capital
99 Working Capital
99 Working Capital
Desired Output:
Id Loan Proportion
94 Expansion 66.67%
94 Working Capital 33.33%
95 Working Capital 83.33%
95 Inventory 16.67%
Thanks, S