Create a new module with TIME (and others) as dimensions from a module where TIME is a line Item

New Contributor

Create a new module with TIME (and others) as dimensions from a module where TIME is a line Item

I have a module called Sales: dimension is a list,Employee-Product Groups. Line Item is Units Sold and Time Period (MONTH). I want to create a module with 2 Dimensions ,  Employee-Product Groups and TIME, and the rest of the line items.

Please help.

Message 1 of 3
2 REPLIES 2
Community Boss

Re: Create a new module with TIME (and others) as dimensions from a module where TIME is a line Ite

When you create a module, the TIME will default to the columns, so just drag in Employee-Product Groups to the pages and enter the desired line items

If you are trying to change the 'applies to' after the module has been created, click on the timescale column in the blueprint and choose the applicable time scale.  Remember to then adjust the line items too

Hope this helps

David

Message 2 of 3
Super Contributor

Re: Create a new module with TIME (and others) as dimensions from a module where TIME is a line Ite

Hi Ms Peach,

 

Assuming your new module is called Units Sold with 1 LI called 'Value', then

 

Units Sold.Value = Sales.Units Sold[sum:Sales.Time].

 

Thanks,

LipChean

Message 3 of 3