Chart from previous period

[Robbie Doo]

I created a report with 2 pie charts. One showing the chart for the current 6
month period and the other the previous 6 month period. However, our 6 month
periods are set from Apr-Sep and Oct-Mar (which is a separate table listing
all the periods every year). Everyone month we have a meeting on a certain
day (usually middle of the month). I run the current chart accroding to the
Meeting Date and the previous chart is pulled with DateDiff of 6 months from
that date.

I was just wondering if it is possible to pull the previous 6 month chart
using the Previous Period instead of DateDiff of 6 months from the Meeting
Date?

If this wasn't enough information to go by please let me know. Thanx

 

[S.Clark]

It is very possible. Store the current and previous period start dates in a
table, then use those values for the query.