Skip to Content
Aug 03 at 02:28 PM

Analysis for office: Dynamically retrieve prior period



We ar using AfO reports on Group reporting. What we want is reports that automatically show 2 collumns of data: The current period (as selected by the user in the prompts) and the prior priod for comparison. How can we create that without having to select the two periods every time?

And idealy we set the collumns up as separate measures so we can create a calculated measure to calculate the variance.

Kind regards,

Robert jan