Forum Discussion
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...
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
Remove Quartal which is right after All.
New formual attached:
Cumulative_Actual =
CALCULATE (
SUM(Alles[Media Net exkl. WZ]) + SUM(Alles[Posting Net]);
FILTER(ALL (Alles);
Alles[Quartal] <= MAX(Alles[Quartal]))
)
Already edited it that way (Because you edited your first answer)
Its missing the "Frango" Column, it should be considered somehow.
The result i get now is the total of all frangos.
And also, i need 4 columns, not 1 that is the total.
Anonymous
Have you put frango as rows, Quarters as Columns and values will be the new measure?
On a matrix and not on a single table
Yes i do.
Expected for first frango:
- Is it possible to share the work space?