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
<tbody>
</tbody>
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
I managed to make the desired report as
customer ID, amount paid, date paid in ROWS, TABULAR NOREPEAT NOBLANK
| ID | amount | date |
| ID_A | 100 | july 7th |
| ID_A | 100 | july 8th |
| ID_B | 100 | july 8th |
<tbody>
</tbody>
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
