how to access data in old account hierarchy FRS report

Summary:

We are building a new account hierarchy with start date 10/1/2025 and in one of our reports we have column which reports on prior YTD amounts. For example if the accounting period selected is Dec-2025 for remaining columns, Prior YTD reports on Dec-2024. When we create new account hierarchy this column data gives #MISSING error. Is this because new account hierarchy starts on Oct-2025? If so how to report on older data?

Please advise. Any information is greatly appreciated.

Thank you.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):