Pivot - Rows showing as subgroups instead of main groups

[Vcoppens]

Hi,
I have never encountered this and I am puzzled.

I have a table with a column with past due DAYS.

There are 4 extra columns with a formula that determines:
Column 1: IF(AND(A2>=30,A2<=59),"30-59","")
Column 2: IF(AND(A2>=60,A2<=189),"60-189","")
Column 3: same formula but then "190-364"
Column 4: same formula but then "365+"

When I try to create a pivot table instead of having 4 row labels with specific headers such as below and thus allowing me to count the number of items and sum the total of those items
- 30-59 10 $2000
- 60-189 2 $1000
- 190-364 1 $ 500
- 365+

I have
-
-
-
365+
- 190-365
-60-189
-
-30-59


I have searched to what the reason could be but to no prevail.

The picture below shows the result and that is obvious not what I was looking for.

Thank you very much,

Has anyone experience this before? And how to solve it.

 

[Vcoppens]

The left is a basic table.
Days delinquent is the given data.
Formulas are added in the columns 30-59; 60-189; 190-364; 365+

The pivot should reflect 4 rows and per row in each column:
The total amount
The number of past dues

However it only show 30-59 as the main row, the other data 60-189 shows as a sub row and the data from 190-364 and 365+ is not showing. In addition I do not need the data from days that are not past due. In this case 16 days is not past due but it is still adding the 500 to the total ....

Thank you,