Pivot table not picking up row with same data

[Krevis]

Took my first step into the wonderful world of pivot table, but i can't seems to word the following problem into the search bar. Duplicate data, data not picking up etc all leads to range error, but I'm sure its not a range error. (or is it...)


I managed to make the desired report as

customer ID, amount paid, date paid in ROWS, TABULAR NOREPEAT NOBLANK

[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]amount[/TD]
[TD]date[/TD]
[/TR]
[TR]
[TD]ID_A[/TD]
[TD]100[/TD]
[TD]july 7th[/TD]
[/TR]
[TR]
[TD]ID_A[/TD]
[TD]100[/TD]
[TD]july 8th[/TD]
[/TR]
[TR]
[TD]ID_B[/TD]
[TD]100[/TD]
[TD]july 8th[/TD]
[/TR]
</tbody>[/TABLE]


Great!

Except.... if i have two of [ ID_A $100 ] on same date, pivot table don't list them
By adding date to table, I managed to list the July 8th data (before it only listed single transaction by ID_A)

But two of july 7th payment by ID_A is identical to each other in all possible data i can think of except the time... unfortunately we don't record time of receipt

Must i think of some other differentiating factor and add it to the pivot? or is there option somewhere to include duplicate?

I'm using Excel 2016