Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sum Columns up (Quarterwise)

Hello all   In the picture below, i have 4 columns that display the 4 quarters of the year.   Now, i need Q2 to be the Sum of Q1 and Q2. Q3 = Q1+Q2+Q3 and same for Q4. So Q4 would be 2'361...
Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    Anonymous

     

    Please change the formula to this one:

     

    Cumulative_Actual = 
CALCULATE (
        SUM ( Sheet1[Value] ),
        FILTER (
            ALLEXCEPT( Sheet1, Sheet1[frango]),
            Sheet1[Quarter] <= MAX ( Sheet1[Quarter] )
        )
    )

    Aslo you can see the formula in this workspace

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yes i do.

 

Expected for first frango:

themistoklis's avatar
themistoklis
Community Champion
7 years ago
Is it possible to share the work space?