Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Matrix - Creating Cumulative Sums Across the Columns

Hi there,

 

I am trying to get a matrix that looks at the cumulative number of orders depending on when a customer made their first order.

 

The column headers are the order dates, the rows are the date the customer placed their first order:

 

 201820192020
2018100120145
2019 150190
2020  200

 

In this example, 100 customers made their first order in 2018 - in 2019, these customers placed an additional 20 orders, taking their cumulative total to 120.

 

So far, I have used the matrix visualization to get the number of orders placed as such:

 

 201820192020
20181002025
2019 15040
2020  200

 

 

How can I take this data and create the top matrix?

 

I have tried using the running total quick measure, summing the number of orders across order date (column header) but this just recreated the bottom matrix when I used this measure.

Any help is greatly appreciated!

1 Reply

  • v-diye-msft's avatar
    v-diye-msft
    Community Support

    Hi Anonymous 

     

    you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.