Stop Report Filter From Aggregating Dates

[EnigmaMatter]

Hello,

The office I work at has recently upgraded to Excel 2013.

There is a PivotTable that is populated with accounting data.

I've noticed that the PivotTable Report Filter for Transaction Date is aggregating older purchase dates, i.e. <12/30/2013,

I do not want it to do that, I want it to list each date separately for selection (filter), i.e. 12/1/2013, 12/2/2013, etc.

Any ideas?

[EnigmaMatter]

Hello All,

I have attached a photograph of what I mean.

I don't want it to do this. I want it to list each date separately.

[Izandol]

It appears that this field has been grouped - you must only ungroup it.

[EnigmaMatter]

How do I do that?

[Izandol]

You must move this field to row field area then right-click and select Ungroup.

[EnigmaMatter]

Excellent! Thanks again, Izandol!

[Izandol]

You are welcome.