Have a line item that does not apply to a dimension, not repeat itself

Options
MatthewWilcox
MatthewWilcox Member, ALL USERS Posts: 5 New Contributor
in Planning & Modeling

Hi guys,

 

I am wondering if there is a way to have line items that do not apply to a specific dimension, not repeat itself within a dimension. I have a list that has another module storing details about the list and then another module which has the time dimension look at revenue for specific accounts. I have pulled through the revenue data from another module but would like a few additional line items before the time dimension.

 

I have attached an image that should hopefully show what I am trying to achieve. as you can see the agency inf is repeated each month. I would like it to show before Jul and then have the monthly data appear afterwards

MatthewWilcox_1-1658448225566.png

Thanks.

 

Tagged:

Comments

  • MatthewWilcox
    MatthewWilcox Member, ALL USERS Posts: 5 New Contributor

    Hi Mark,

     

    Yes the Agency is a list dimension. But if I add it as a dimension to the module wouldn't that increase the number of cells by a factor of the number of Agencies in the list?

  • DaanishSoomar
    DaanishSoomar Member, ALL USERS, GroupMember, Partner, User Group Leader, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

    1 approach is to simply remake that line item in a separate module with the desired dimensions. This will eliminate the subsidiary view and maintain better user experience. Regarding your question about list dimension - if you add it as a dimension to the module it would add that many number of cells. If you don't need it, consider storing the line item in a separate module. Here is a Planual principle related to this: https://community.anaplan.com/t5/Chapter-2/2-01-06-Avoid-Using-Subsidiary-Views/ta-p/76835

Categories