Summing a line item based on time period in another line item

I'm attempting to come up with a total amount per period. However, the module I'm working with is not dimensioned. I have a month formatted line item called 'Period' and am hoping to sum up the 'Amount (LC)' line items that correspond with each Period entered. For instance, I'd like to see a total sum of the individual 'Amount (LC)' values entered for October 2020.

Is this possible without having a time dimensioned module? Do I need to create a line item subset?

Screenshot_(2)_LI_120477.jpg

Accepted answers

All comments

andrewtye

Why not just create a time dimensioned module, use sum and it'll give you what you want?

Then if you wanted to have a column that gave cumulative you can use lookup against the new module.

ChrisAHeathcote

Create a time dimensioned module and use SUM to aggregate the valued into each time period using the month formatted line item in the source as the mapping.

@andrewtye is correct. The easiest solution is to use a time dimensioned module to sum each entry into its corresponding month

andrewtye

It has been known that I am correct on occasion! 😁

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…