Forum Discussion

vinothkumar1990's avatar
vinothkumar1990
Helper II
2 years ago
Solved

Table Matrix Report Total Sum Issue

Hi All, I have requirement to calculate the cumulative sales for each month with the below rows and columns. Rows - Region and Country Column - Mon-YYYY Values - Sales (Sales Amount) Sample ca...
Need Help
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    Hi vinothkumar1990 

    Try below Calculated column not measure.

    Sales 2 = CALCULATE (
        SUM ( 'Region Sale'[Sales Amount]),
        FILTER (
            FILTER ( 'Region Sale', 'Region Sale'[Country] = EARLIER ( 'Region Sale'[Country] ) ),
            'Region Sale'[Mon-YYYY] <= EARLIER ( 'Region Sale'[Mon-YYYY] )
        )
    )
     

     

     

    I hope this works for you.!

     

Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi vinothkumar1990 

Try below Calculated column not measure.

Sales 2 = CALCULATE (
    SUM ( 'Region Sale'[Sales Amount]),
    FILTER (
        FILTER ( 'Region Sale', 'Region Sale'[Country] = EARLIER ( 'Region Sale'[Country] ) ),
        'Region Sale'[Mon-YYYY] <= EARLIER ( 'Region Sale'[Mon-YYYY] )
    )
)
 

 

 

I hope this works for you.!