You need to sign in to do that
Don't have an account?
Christopher Taylor
PREVGROUP VAL Looping to Groupings not Under Parent Group
I am using PREVGROUPVAL to calculate YoY change by month (Sales in january 17' vs Sales in January 18). It works fine, but it is assigning a value to February and March of 17' by comparing it to January and February of 18'. It should leave these blank. See attached image. I need this comparison only to compare values within the parent group (Month in this case). I have the report grouped as follows
Created Date: Month In Year
----Created Date: Year
Created Date: Month In Year
----Created Date: Year