SUM by Quarter

Options
NancyKhurana
NancyKhurana Member, ALL USERS, Community Member Posts: 5 Occasional Contributor
in Planning & Modeling

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 ?

Tagged:

Comments

  • NancyKhurana
    NancyKhurana Member, ALL USERS, Community Member Posts: 5 Occasional Contributor

    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. 

Categories