SUM by Quarter

I want to sum the milestone values by each quarter in a different module(Line item).

NOTE: Quarter period(Line item format)in Quarter line item is from time scale and not model calendar.

Source Module has three dimensions:

Target module where sum of milestone values need to be calculated has two dimensions:

NOTE: Neither of the module has timescale applied to it .

How can I sum the milestone values by each quarter ?

Accepted answers

If you don't have quarters in your target modules how you plan to show the final output. Where you will land values for Q1,Q2 etc. separately?

Are you planning to have separate line items for each quarter?

Thanks

Abhay

It can be line items in the target module and we can even create a list with quarter members(Q1,Q2,Q3,Q4) and pull it in dimensions in the module.

If you want to use a list in the target module then I would suggest use the Time dimension only. Follow the below snips for the result

Below is the Target Module

You can use your 'Time range' as well in the target module in place of Model Calendar. It will give you the desired output

I hope it helps

~Anand

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…
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.…