Tag: sum

Aggregate

Overview Settings Period Percentage Rolling Examples Questions How do I calculate a rolling sum? How to keep series as is and start aggregating it from certain point in time? Overview Example of general use of Aggregate analysis comparing aggregated values by each year annually and starting 3 year from the end of series: The Aggregate … Continue reading “Aggregate”

How to add/sum up series?

If you want to sum values across few series, there are two main ways to achieve this: 1. Formula language You can sum multiple series by typing a simple expression with the ‘+’ sign. It will add up only common part for all series. 2. Cross Section analysis Use the Cross section analysis to calculate … Continue reading “How to add/sum up series?”