Segment and Cumulative Segment Banding
I use banding all the time to group customers into segments. Very easy. But I also have a need to group those bands in a cumulative matrix such that each band has a cumulative total inclusive of the bands above it. You can see the example below: How would I write the DAX to produce the matrix on the right from the data on the left?
