Drillback from YTD scenario

camagruder
New Contributor III

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 1

Steven
Contributor

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.