Need Formula Help
Hi all -
I am very new to Anaplan and have just finished the Intro to Model Building. As a test for me before going into Intermediate Model Building, I tried to set up a copy of a report I currently have in Excel. The report is to show revenue by PI for each month & the % of their revenue at the site they are located. I have uploaded in January data for the revenue & have the Anaplan report that shows the site total & revenue by the associated PI, but am stuck on how to get the % of revenue. Below are screen shots of my List Set-up, the PI List, the Anaplan report & the Excel report I'd like to replicate. All help is greatly appreciated.