I am trying to calculate the percentage of the withdrawal categories from the deposit of each year. For example, in 2013, the Other row should give me a percentage of 5/1336.47.
In 2017, the Entertainment row should give me a percentage of 53.62/15522.90. The food row should give me a percentage of 456.14/15522.90, and so on.
Copy of Finance.xlsx -- I attached the OneDrive link for better clarity, which has randomized data for anonymity. The column near the pivot table is how I want the percentage to look like.
How can I do this? Thank you for any help you can give me.