What formula do you want to write? And what will be the source and what will be the receiver? If you are going from P1 to P5, then you need LOOKUP. And if from P5 to P1, then the system will be able to add the data in the hierarchy itself (if your list if composite).
It's hard to say, I need a screenshot of the blueprint / module. It is likely that you can calculate the percentage of the increase in detailed measurements and put the summary = formula. Then subsidiary view will not be needed.
Can you show me "Applies to"? Based on the list of analysts and formulas you have written, you can get the correct numbers in the first line item for calculating growth. And for displaying on dashboards, use filters.