Pivot Table Date Sort Options

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI.

I have several Pivot Tables based on Access Queries which I use to track
company data on a monthly basis over several years. I use dates in both Row
Filters and Column Filters grouped by Month and Year.

The default order is the Calender Year which does not match our trading
time-line. We instead need it sorted by our Financial Year of July-June.

Is there any tips or options which I might try?

Thanks in advance.
 
Mark,

use an auxiliary table that matches months to FY periods, something like
CalMonth Period
Jan P07-Jan
Feb P08-Feb
....
Jun P12-Jun
Jul P01-Jul
....
Dec P06-Dec

add the table to your query design or use a DLookup in a calculated field,
and use the period field instead of the calendar month; this will get the
sorting correctly.

HTH,
Nikos
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table - Quarterly report 1
Apply Month End date based on transaction date 5
Table, form etc... Data Type 1
grouping dates in a pivot table 1
Sorting Month-Year in Query 7
Query to Complex with Criteria 1
Date Serial Problem 2
Sort pivot table field (droplist) by month or original data 1

Back
Top