I want to sum actual data by account and Time.

I want to sum actual data by account and Time..xlsx

I want to sum actual data by account and Time..png

As shown in the image, actual data is on the left and detailed data is on the right.
The detail data is created to be in the hierarchy below the Department Code that we want to total.
I want to sum from left to right by Account Code and Time.
I am thinking that I need a System Module to use the Sum function, but I can't come up with an idea of what items to have so that I can Sum.
If you have any good ideas, please let me know.
A demonstration actually created in Anaplan would be very helpful.
Thank you very much.

Accepted answers

All comments

lokeshm

@Tkinoshita you need to create on time custom list to achieve your requirement.

Now create On time custom list and import the Date text line item into your list.

Now create another module for your calculations.

This will display data in this way

Only drawback in this type is you need to run the import action every time you have new date Recorded .Hope this helps you .

Tkinoshita

@Lokesh_Madhu

I want to sum actual data by account and Time.(2).png

I want to sum actual data by account and Time..xlsx

Thank you very much. Thanks to you, we are much closer to our goal.
However, it is not yet complete.
The biggest problem is that I have to tie it to the Time of the original Detailed data. (Sheet2)
Otherwise, the Actual results will be displayed in the Time DATA list, which has nothing to do with the Time of the Detailed data.
If possible, I would be very happy to get some good ideas on how to work around this situation.

lokeshm

can you share the screen shots from the Anaplan .

lokeshm

I have used the below formula o achieve the results by Departments for the Actual results.

Tkinoshita

@Lokesh_Madhu
I noticed the real problem while making screenshots of Anaplan.
Thank you once again for your help.

Now, if I could share the problem,
I noticed that the “SUM BY ACT AND TIME CALC” module you created has a Department axis.

I would like to make this axis as Detailed data.
Please see the screenshot in the attached Excel for more details,
I would like to get the totals with having the Detailed data and the Time LIST on the axis.”
Can you please reiterate if this is possible?

I want to sum actual data by account and Time.(3).xlsx

lokeshm

In the module 1 that you created doesn't have any mapping with the detailed data. you should have one line item in the module 1 to create mapping between results data and detailed data

create another line item formatted to detailed data and select values . In the second module , in the sum formula refer this line item as well along with time one.

Tkinoshita

I created the list by adding the detail data and TIME_LIST together as shown in the attached image.
Does this mean that I can bring the Actual results from the actual data in this way?

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385