Pivot table will only show date on first transaction but not subsequent transactions in same date

[gw2011gw]

Hi,

I have a pivot table, Date is one of the columns, however, if there is more than one transaction in the same date, the table will only show date on the first transaction but blank date for all other transactions in the same date.

Technically it is fine, but for presentation, I would like to have all dates shown.

Can someone please show me how to make date show for all transactions in same date.

Thanks in advance.

 

[sheetspread]

In Design - Report Layout choose Repeat All Item Labels

 

[gw2011gw]

Thanks for the reply, unfortunately I do not see that option in Design - Report Layout, maybe it is because I am using a 2007 version ?

 

[sheetspread]

2007 is similar to 2010 (which I have) in many ways, but perhaps not here:

https://www.mrexcel.com/forum/excel-questions/693130-repeat-item-labels-excel-2007-a.html

 

[gw2011gw]

ok, got it. Thanks

Also found this alternate filling method:

https://answers.microsoft.com/en-us...vottable/306a3c8f-d7c7-460b-b046-950646ac0427