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 ?

Answers

  • @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

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

  • @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

     

     

    https://in.linkedin.com/in/anand-shekhawat-35645486