Forum Discussion

camagruder's avatar
camagruder
New Contributor III
2 years ago

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. 

 

 

Data Sources
  • Steven's avatar
    Steven
    Contributor II
    2 years ago

    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.