Department as a % of Total Revenue
I am currently trying to develop a model that references two different regions within a list (that is production data).
Let's say we have 2 line items:
New England Revenue
Total Company Revenue
I want a ratio where I can reference our P&L (300ish line items) and say P&L Revenue [Select: List.New England] / P&L Revenue [Select: List.Total Company] but with it being production data I am unable to reference it.
Is there a work around for this?