I actually need to show duplicates in pivot tables

[matts12]

Hi there I have a table containing the following headers. Invoice number. Customer. Amount Date Issued.
When I set up my pivot table I have in the first column. Years, Date Issued (months), and customer.
The second column in values section I have invoice number.
The third column I have amount.
And the last column I have Date Issued where it shows the actual day the invoice was issued.
Now setting up that way works exactly how I want it to work, however when I get a repeat customer in a certain month, it doesn't show me the duplicates. Instead it shows the customer once and totals the invoice numbers and all the other columns. I need to show the invoice numbers individually. I use excel 2021 and don't know how to set it up to show how I want it to display on my report. One workaround is to add date issued to the first column again but that messes up my report and doesn't look professional. Any help would be appreciated. All I can find is how to remove duplicates. In my case I need to show them

 

[GraH]

With a normal pivot it can't work, since you have the invoice number in the values section.
When you move to data model and power pivot, you can actually create a measure for it that concatenates the invoice numbers.
Mr Excel has done a video on that a while ago. But you can find it back on YouTube.

 

[matts12]

With a normal pivot it can't work, since you have the invoice number in the values section.
When you move to data model and power pivot, you can actually create a measure for it that concatenates the invoice numbers.
Mr Excel has done a video on that a while ago. But you

I appreciate your reply. However when I get a customer 20 times a month I don't want 20 items showing up on 1 row. I need it to be a list. What am I missing here. Is there a way I could do that with formulas and power query? Sorry for my misunderstanding

With a normal pivot it can't work, since you have the invoice number in the values section.
When you move to data model and power pivot, you can actually create a measure for it that concatenates the invoice numbers.
Mr Excel has done a video on that a while ago. But you can find it back on YouTube.

 

[matts12]

I figured it out. Just put a space behind customer name wherever the duplicates are in your data and it works exactly how I want it to. You notice nothing in your pivot table