Skip to main content
Newcomer
Jun 29, 2023 1:38 PM UTC

Drillback from YTD scenario

When using drill down to drill from a periodic value back to a connector business rule on a scenario that was loaded as YTD, is there any way to show the "Load Results from Imported Cell" as Periodic instead of YTD?  I would expect the drilldown to keep the same view. 

 

camagruder_0-1688045610134.png

 

1 reply

Contributor
Jun 29, 2023 7:44 PM UTC

Not easily.

You would need to write a sql query that would look at the prior period and subtract out the current period from the prior period. 

Probably not best practice, and it wouldn't get you to the original records, it would drill back to calculated records.