For the first part, I'm wondering if it might be useful to make a separate calculated field for each Tier,
for example, for Tier1:
WINDOW_SUM(IF [Running Sum Customer Count]>=21 THEN 1 ELSE 0 END)
These three would be placed on the Measure Shelf with Table Calculation Settings shown below.
This creates many copies of the value, but this can be filtered down to one with INDEX() on the Filter Shelf.
Please see workbook v10.3 attached in the Forum Thread:
288851tier_v10.3.twbx 4.5 MB
Hi Swaroop, that worked wonders!! Thank you. I now can summarize by Tier. The only thing I had to change on the Summary tab is the Date field. I used the "NewCustDateForTierGroup" field instead and that gave me the desired results. Thanks so much. Now onto the second part:):)