Hello
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. 0x80070490 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.
thanks
iosman
Hi iosman,
This is certainly possible. Simply create a new line item called Total Sales, without any dimensions and with the formula as Sales.
Then create a third line item called % of Total Sales with the formula as Sales/Total Sales
This works because your products hierarchy has a top level called Total Products
Please let me know if this helps!
Regards,
Anirudh
Hi Iosman,
Unfortunately I have a very complicated answer for your very simple question, but it does work. It will require a few more line items though! If I understand correctly, you want to see the percentage of each product relative to its parent. As in the following screenshot:
Sidenote: I have a rather standard way to determine which level of the hierarchy the cell is refering to. I use this for filtering tables where I want to show a certain level, while I want to use synchronize selection on the dashboard (selecting levels in a view, disables the synchronize selection function), but it can also be useful for these kinds of formulas. In order for this to work, you need to know how many levels the list will have and it will require maintenance if you add another level.
Here are the steps to create this result:
Hope this is not too complicated!
KR,
Bram Kurstjens