Pivot table - show items with no data maintaining subcategory

[joaolucasd]

Hi,
I have a table that I use to track my expendings every year. I have three main categories (Taxes, Recurring Expenses and Atypical Expenses). Under each category, I have a number of expenses, like this (I'm making this up, since I'm from Brasil and taxes and expenses are different than in english:

Type of expense	Name of expense	Value	Date	Month	Year
Taxes	Income tax	$500	1/1/2020	january	2020
Taxes	Housing tax	$200	1/1/2020	january	2020
Recurring Expenses	Rent	$400	2/1/2020	february	2020
Recurring Expenses	Water	$100	and so on...	and so on...	and so on...
Recurring Expenses	Energy	$50	and so on...	and so on...	and so on...
Atypical Expenses	Gas	$100	and so on...	and so on...	and so on...
Atypical Expenses	Parking	$30	and so on...	and so on...	and so on...
Atypical Expenses	Clothes	$200	and so on...	and so on...	and so on...
Atypical Expenses	Farmacy	$100	and so on...	and so on...	and so on...

I want the pivot table to show, every year, this list of expenses under the same category listed on the table, even if there is no value in them. When I select "show items with no data", the pivot table messes up, losing the subcategories. It starts to show something like this:

Taxes
Income tax
Housing tax
Rent
Water
Energy
Gas
Parking
Clothes
Farmacy
Recurring Expenses
Income tax
Housing tax
Rent
Water
Energy
Gas
Parking
Clothes
Farmacy
Atypical expenses
Income tax
Housing tax
Rent
Water
Energy
Gas
Parking
Clothes
Farmacy

What I would like is to maintain the subcategories in the pivot table, even without data on them (like when I star a new year). Is this possible?

 

[joaolucasd]

I'm sorry, the example is not good... I tried using spaces, but it formatted differently. What I wanted to say is:

It starts to show something like this:

Taxes
Income tax
Housing tax
Rent
Water
Energy
Gas
Parking
Clothes
Farmacy
Recurring Expenses
Income tax
Housing tax
Rent
Water
Energy
Gas
Parking
Clothes
Farmacy
Atypical expenses
Income tax
Housing tax
Rent
Water
Energy
Gas
Parking
Clothes
Farmacy

and what I want is:

Taxes
Income tax
Housing tax
Recurring Expenses
Rent
Water
Energy
Atypical expenses
Gas
Parking
Clothes
Farmacy