SUM by Quarter

NancyKhurana
Occasional Contributor

SUM by Quarter

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

NancyKhurana_2-1625590867349.png

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

NancyKhurana_4-1625591238983.png

 

Source Module has three dimensions:

NancyKhurana_1-1625590821382.png

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

NancyKhurana_3-1625590968301.png

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

 

How can I sum the milestone values by each quarter ?

3 REPLIES 3
abhay.kanik
Regular Contributor

Re: SUM by Quarter

@NancyKhurana 

 

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

NancyKhurana
Occasional Contributor

Re: SUM by Quarter

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. 

anand.shekhawat
Super Contributor

Re: SUM by Quarter

@NancyKhurana 

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

anandshekhawat_3-1625641379179.png

Below is the Target Module

anandshekhawat_2-1625641330123.png

anandshekhawat_4-1625641595464.png

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