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

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's avatar
themistoklis
Community Champion
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      themistoklis
      Community Champion
      7 years ago

      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's avatar
        Anonymous
        Not applicable
        7 years ago

        Yes i do.

         

        Expected for first frango: