About Chmacpherson

Chmacpherson

Akhtar, Unfortunately neither the all or any options makes a difference. The aggregation column still disappears. Thank you for taking the time to suggest a possible solution. Cheers, Chad

Chmacpherson

Hey Anaplan Community, I am hoping someone can help me understand how to filter my grids to view only the forecast periods while not removing the FY aggregation column. In the course, it shows that my dashboard should look like this: Unfortunately mine does not. I have a tradeoff occuring where I can either start the grid in the months of 2019 and have the FY columns, or I can start with the months of 2020 but lose the FY columns. Any suggestions? Many thanks, Chad

Chmacpherson

Thank you! Super helpful

Chmacpherson

I struggled with this as well and had to search multiple threads for the answer, so here is hopefully a more concise version of the various solutions. *View the screenshots for a little guide* 1) Make sure your E2 Employees# list is properly set up as a numbered list. Refer to Model Builder 1 lessons: 4.3.4 4.5.4 4.8.2 2) As the E2 Employees# list is a numbered list, you need to map the Target "E2 Employees#" to Column 2: Code instead of Column 1: Employees as Anaplan will not be able to match 001 to Shala Engle. 3) The dates in the csv file are formatted as "Fixed-position" patterns (YYYYMMDD) versus a "With Separators" pattern (YYYY-MM-DD). You'll need to tell Anaplan this when mapping to ensure it reads these as dates. I hope this helps, Chad

Online Status	Offline
Date Last Visited	Thursday

About Chmacpherson

Re: 14.4.3 Classic Dashboard: Troubles Formatting ...

14.4.3 Classic Dashboard: Troubles Formatting Grid...

Re: 8.5.3 Activity: Import Data into Volume Inputs...

Re: Error in level 1 Activity 7.2.3 : Unable to Im...

Re: Level 1 Model Building certification exam: hel...

Re: 8.5.3 Activity: Import Data into Volume Inputs...