Hi Ed,

Thanks for your reply.

The insertion of extra rows is what I want to avoid. If that is the
solution, I can keep the situation as it is, i.e. group and ungroup.

Preferably I like a formula like lookup or something. I think that I will
than only have to make the formula once for every quarter and not have to
bother anymore for the rest of the year.

Kindly advise.

Kind regards,
Eucalypta

"Ed Ferrero" wrote:

Hi Eucalypta,

You can drag-and-drop quarters to whatever order you want.

Otherwise, remove all row fields except the weekEnded date, then sort by
date, then add row fields to the pivot table. The pivot table should remain
sorted by date. Note that whenever grouping dates, I usually add both year
and quarter (or month) to the row fields to avoid confusion.

Ed Ferrero
www.edferrero.com