I need to create a chart that takes this into account:
The difference between Current Months Values and the average of the previous three months.
My confusion lies in having two separate time periods.
Is there a calculated field I can create? Thanks for your help in advance.
I am not quite sure what you mean. Are the Current Months and Previous Three Months 2 separate fields? Would you be able to post your workbook (saved as a twbx file) so I can take a closer look?