Line Items with Version LIS

Options
Bhavesh
Bhavesh Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi,

 

I have a P&L with 20 line items currently in a module. This has 2 other dimensions Entity & Division which are Lists. It has native versions as well and monthly time.

I'm trying to create a new module which takes some lines from this P&L with different combinations of Entity & Division which I'm comfortable creating using Select statements.

 

However the issue I'm faced with is I need to create a report which has versions and variances such as Actual, Forecast, Var, Prior Month, Prior Month Var, Last Year, etc.

 

I have created a separate module for versions and tried using this as a Line Item Subset (LIS) but for some reason cannot get data down to the P&L line item, all I get is the same number across all P&L line items.

Any help is appreciated.

 

Tagged:

Categories