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.
Transactions.twbx 42.8 KB
Hi Ken. Thanks for your assistance. I just tried to use the main data that I wanted to use and tried to follow your example. I still don't get the list of 'Name or Type of transactions' that we you obtained it, which what I am looking for. Instead, I get the following. I'm quite certain that I am close to the solution that you presented. Instead, I obtain the following. What do I need to do to get your version with the list of all transactions and Sum for each type of transaction?
Thanks again for your assistance!