Forum Discussion

gtamir's avatar
gtamir
Post Patron
8 years ago
Solved

CumulativeTotal by Index

Hi

I am trying to create a cumulative column from the Total and Index column in the table SalesByCustomer.

What is wrong in my formula?

Thanks Giora

Need Help

4 Replies

  • popov's avatar
    popov
    Resolver III
    8 years ago

    Hello, gtamir
    Correct formula below

    Cumulative Total =
    SUMX (
        FILTER (
            SalesByCustomer,
            SalesByCustomer[Index] <= EARLIER ( SalesByCustomer[Index] )
        ),
        SalesByCustomer[Total]
    )

    • gtamir's avatar
      gtamir
      Post Patron
      8 years ago

      Thanks but it has a problem.

       

      • popov's avatar
        popov
        Resolver III
        8 years ago
        Do you create calculated column?