R
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
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