Sum Columns up (Quarterwise)

[Anonymous]

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'693.

Can i do that with a measure?

Any ideas?

Best regards 

[themistoklis]

@Anonymous

Can you try the following:

Cumulative_Actual = 
CALCULATE (
    SUM ( Sheet1[Values] ),
    FILTER( ALL (Sheet1 ),
    Sheet1[Quarter] <= MAX( Sheet1[Quarter] ))
)

[Anonymous]

@themistoklis

Thanks for the quick response.

I did not get it to work.

I think further infos are needed.

Matrix looks like:

With the fields:

Measure regarding your answer:

Cumulative_Actual = 
CALCULATE (
    SUM(Alles[Media Net exkl. WZ]) + SUM(Alles[Posting Net]);
    FILTER(ALL (Alles[Quartal]);
    Alles[Quartal] <= MAX(Alles[Quartal]))
)

"Alles" is the table. Its only one table with all the infos in there.

I inserted tte result measure as column instead of "Quartal".

What are my wrong thoughts?

[themistoklis]

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]))
)

[Anonymous]

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. 

[themistoklis]

@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

[Anonymous]

Yes i do.

Expected for first frango:

[themistoklis]

Is it possible to share the work space?

[Anonymous]

Not really...

But i will try to create a file with dummy data for you.

[Anonymous]

@themistoklis

That should work just as our original file.

https://iheartmedia-my.sharepoint.com/:u:/g/personal/chccbaa_clearchannel_com/EZ49YIna84xJvuA95ZvY9P...

[themistoklis · Accepted solution]

@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