Forum Discussion
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:
| 2018 | 2019 | 2020 | |
| 2018 | 100 | 120 | 145 |
| 2019 | 150 | 190 | |
| 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:
| 2018 | 2019 | 2020 | |
| 2018 | 100 | 20 | 25 |
| 2019 | 150 | 40 | |
| 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-msftCommunity 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.