Hi,
My financial year run from Apr to March.
If the current date is before the 7th of the current month or after the 7th need to restrict the data in the pivot table.
EG
If Current Date is 5th December - Restrict data to Apr - October (previous month -1)
If Current Date is 13th December - Restrict data to Apr - November (previous month)
I have Fin_Year (2010/12, 2012/13, 2013/14)
Fin_month (1,2,3,4,5,6) Apr,May, Jun, Jul, Aug, Sep.......
Cal_Year (2010,2011,2012,2013,2014)
Cal_month (1,2,3,4,5.....) Jan, Feb, Mar, ........
Any help is appreciated.
Tom