-
Re: Formula showing YTD actuals + Remaining Year Forecast
In the blueprint for the YTD line item, uncheck the Use Switchover Data Results:1 -
Re: Count line items
@Shraddha0706 Create a new line item called Count with the following formula: If Mismatch then 1 else 0 Put a Top Level on the list in the rows and you will have your total.1 -
Re: How to create saved view with specific dimensions
@Gauri Does the 4th dimension have a top level member? If so, put that dimension in the page axis and fix it to the top member (hide all children which can be done using Select Levels to Show). The b…1 -
Re: Dynamic read access
@Tom_H In short, no as the read/write drivers (DCA) is at the cell level, not the dimension level. Could you possibly change this up and create a composite list with 10 rows under each site? If you d…1 -
Re: Import Data Sources / Imports
@ChrisMcCarthy If I am understanding your question correctly, you have it a bit backwards in that when you update the Import tab, that will feed the Import Sources. Import Tab - updating the Source L…1

