Automatically manage MTD / YTD / FY time aggregations, together with organisational / consolidated aggregation, for the following data types: “Stock” type – MTD: monthly value, YTD: same as MTD, FY: value of the last forecast month of the year “Weighted average” type – MTD: monthly value, YTD: average of YTD months (excluding blank values), FY: average of the 12 months of the year “Volume” type – MTD: monthly value, YTD: sum or average from the beginning of the year, FY: sum or average over the full forecast year “Calculated” type – calculated based on other data from the same period or from other periods; the metric must follow the Monthly formula logic “Variance” type – calculated as the difference or percentage change versus the selected comparison scenario

Question

In the same board : Automatically manage MTD / YTD / FY time aggregations, together with organisational / consolidated aggregation for different type of data (volumes/financials, stocks, average/ratios, calculated metrics, ....)

+1

Automatically manage MTD / YTD / FY time aggregations, together with organisational / consolidated aggregation, for the following data types:

“Stock” type – MTD: monthly value, YTD: same as MTD, FY: value of the last forecast month of the year
“Weighted average” type – MTD: monthly value, YTD: average of YTD months (excluding blank values), FY: average of the 12 months of the year
“Volume” type – MTD: monthly value, YTD: sum or average from the beginning of the year, FY: sum or average over the full forecast year
“Calculated” type – calculated based on other data from the same period or from other periods; the metric must follow the Monthly formula logic
“Variance” type – calculated as the difference or percentage change versus the selected comparison scenario