Below is a rough draft. I created three calculated fields:
Note that when you enter these formulas, it's a good practice to set the Default Compute Using. In this case it should be set to Cancel date, which is the dimension the table calcs are being compute over below.
Original Class Size =
// When set to compute using Cancel date, this will count the // number of customer IDs, regardless of Cancel date. TOTAL(COUNT([Customer ID]))
[Original Class Size] - RUNNING_SUM(COUNT([Customer ID]))
Remaining (%) =
( [Original Class Size] - RUNNING_SUM(COUNT([Customer ID])) ) / [Original Class Size
Now you can drop these into a view. Remaining will have a Null column. Drag this to the end and select hide (not exclude, since you need these rows to calculate the original class size).
Survival.twbx.zip 18.0 KB
Jim - This was a tremendous help. As a noob I didn't (possibly don't) fully understand the subtleties of the measure names/measure values shelves and table calculations. Your post of a functioning workbook and clear explanation of the necessary functions was a huge help in my understanding of this.
For anyone reading this down the line, the only challenge I had to the above was moving the "Null" column to the right of the table, so the running sum wouldn't pick up still active customers. Being relatively ignorant, for awhile I was wondering why the "Remaining" calculation was off. Obviously it wasn't!
You're welcome. Thanks for the additional clarification on the null column.