Skip to main content
Newcomer
June 29, 2023

Drillback from YTD scenario

  • June 29, 2023
  • 1 reply
  • 0 views

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
June 29, 2023

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.