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

Options
aschmaling
aschmaling Member, ALL USERS, Partner, Certified Model Builder Posts: 2 New Contributor
in Planning & Modeling

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? 

Tagged:

Categories