How do I sum across dimensions other than time?




Can't see how this was done in the allocations video. I have a list for products, and a line item for sales. I want to introduce a line item that returns the total sales for all products against every product. Beyond allocation use, is there a way to introduce a line item that returns the value at the next level up a multi-level hierarchy? - Assume we have a three level product hierarchy: Product>Product Group>Total Products. Such a function would enable me to return the % contribution that each Product contributes to its Product Group, and the contribution that each Product Group contributes to Total Products. bsod





  • Hi,


    We can get the %contribution at different levels. Please see the screenshot. Try this

    Hierarchy I have : Product L1->Product L2->Product L3



    if you want a line item that returns the value at the next level up a multi-level hierarchy(Example Product L2), 



    I think this will clear your doubts,



    Vignesh M

  • Hello,


    Vignesh got it almost right, from your question i understand you need a product group rollup into total products. You could have a module by product group and calculate the % contribution.image.png

    Note: I was quick and dirty to use a select, but you cannot use select on a production list. You need to change it accordingly, one way is as below,








  • Hi @iosman123 


    I noticed that you have posted the same query earlier. I presume solutions presented in earlier post didn't work for you. 

    If you post new reply on the earlier post, it will float to the top of forums again. Please don't create multiple posts on same query, which might confuse the learners who may have same question.







  • Indeed, this has been asked before:

    Please reply to the answers posted there, people are putting in effort to help you out, it is only decent to let them know whether they did.


    Bram Kurstjens