Hi all,
I am trying to find a way to calculate the Sales % of a items parent, and also of the Parent of the items parent.
Below is an example of what I am trying to achieve,
Hi @GMS ,
You can achieve this by setting the summary as ratio.
Here I had created couple of line items
Sales - For entering data
Total - It will be having parent as dimension so Sales will be summing up and coming here according to its parent.
Total 2 - To get parent sumup data against all child member { Total[lookup:parent] } .
formula for finding % is Sales / Total 2.
And to get summary create one more line item(All Products) with no dimension and refer sales there so u will get sum of all products value. In summary of % line item keep it as ratio and set Sales / All Products.
I hope this will solve your issue.
Regards,
Akhil
@CommunityMember94297
Percentage to total can be easily achieved with the LOOKUP function. SUM is used when you want to add things up and LOOKUP is used when you need to pluck out one value.
The most effective strategy is to calculate once and refer often. So in this case I'm using a system module (DISCO) and referring to the volume of the respective enterprise. Each store belongs to a DC but in our Store system module we calculate the PARENT of the PARENT.
The key is to calculate once!
You got this!
Thanks @JaredDolich , close to what I want but not quite.
In my example for Fruits, the percentages summed to 100%, each fruit being the percent of Fruits Total.
Then Fruits is a percentage of All Produce.
I can get the Percent of Parent to work fine, but when I select say 'Fruits' it shows 100% and not the percent of total
Thanks @AkhilEmmanual ,
This is working mostly now, thank you!,
One question is the All Product Line item, I can see it has the little grey box next to the name, what setting or input gets me this? This is the last part I am trying to get right.
That is actually subsidiary view. Remove Applies to , Keep it blank. That line item doesn't require any of the dimensions.
Regards ,
Thanks, Figured it out, I have one other dimension in the model that I need to include in the 'Applies to'!
Much appreciated for the quick responses!
I am trying upload data from a CSV with date. For size reasons, I don't want to dimension the module by date but bring it in as a line item formatted as date. The problem is that person that will be doing the upload is in Italy, and their date format is different. When she does the upload, the date gets messed up…
Hi, when I am assigning the account to the territory I am always facing error as below and account never get assigned to the territory , what could be the reason ? When I use same method for unassign it works .
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
