Hi all,
I'm working on a project that requires that I show only records where this months' and last months' data meet a certain requirement.
My data is Sales by Month, so Sales January, Sales Febraury, etc.
I have written the calculations to extract the month from the current date and last month. I'm stumped, though, when it comes to the formula that states 'if this months' sales and last months' sales meets criteria, show record'
Can you please help?
Thanks!
CC
Resolved: I used an If statement; if [this month]='1' then [january data], etc. for each month and then filtered my report for the months I need.