Not quite sure I understand the issue. The structure of the data, as is, should allow you to do what you need. For instance, I pulled in your data and did a quick summary:

I suppose the only thing that is missing are the specific categories you need. If you don't have those categories in your data, you have a couple of choices. First, you could add it to your data. Second, you could use groups in Tableau to create those. The problem with this is that new transaction types will not be automatically added to those groups, so it will become a maintenance problem.

To create the groups, right click on "Name or type of transaction" and select Create then Group.

From here, you can choose how to group each item:

This will create a new data item in your data called Name or type of transactions (group).

You can then use this in your charts. For example, this shows your spending over time using some groups I maade up.

Is this what you're looking for?

See attached workbook.

Did you get this working?

Would you please mark one of the responses as the "correct answer" so we can close this thread and others can learn from it in the future. Thanks!

Hi, just following up on this to see if we've addressed your question or you have additional questions. Please advise.