Grouping line item data?

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

Hi All, I'm new to AP and I have a question.....

I have a module that has Employee, Product Line and time as the dimension. 

My question is how do I tell Anaplan to group by certain products only?

ie. Product Line: Apple, Pears, Oranges, Fig, Lemon, Tangerines. 

I want to group : Apple and Pears into "Fruits" , Oranges and Tangerines into "Citrus" and all "others". Do i need to create another list but I am not sure how to tell anaplan that if the Product Line = Product List return me "Fruits"? 

Tagged:

Comments

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

    Sorry I should have been more specific. Currently the module is used to determined the count of each of these product line. I want to keep this the way it is. What is being asked is to also group these product line into a multiple groups and each of these group will get a target (goal) #. I will then need to determined the % percentage to goal by quarter. The time dimension is currently in Month. 

     

    I did create a subset as suggested but I am still confused on how to 'bring' it into my current module. 

     

    Thanks

  • jarahbe32
    jarahbe32 Member, ALL USERS Posts: 1 Not applicable

    making group isn't difficult 

Categories