We use parent and child projects in our financial dimension set up; child projects have the same base project ID as the parent project with a suffix on the end, like parent project ABC1234 and child project ABC1234-YZ
I'm designing a new report in Financial Reports and need to show data only relating to certain child projects. I've tried using +Project = [*-YZ ] but this isn't accepted by the designer.
I've also tried defining a Dimension Value Set in the same way and, while this is accepted by the designer, when I run the report I get all project data, not just the child.
Is there any way to pull through just the data for the child project on a row?
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.