Forum Discussion

domtrump's avatar
domtrump
Icon for Helper II rankHelper II
2 years ago
Solved

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 ...
  • some_bih's avatar
    some_bih
    2 years ago

    Hi  domtrump 

    In enclosed file you can find possible solution for Measure Count.

    This measure is based on another measures Count 21+ and other, which is based on calculated column Band in Fact table as following
    =IF([Age]>=60;"60+";
    IF(AND([Age]>=50;[Age]<60);"50+";
    IF(AND([Age]>=40;[Age]<50);"40+";
    IF(AND([Age]>=21;[Age]<40);"21+";
    "21+"))))

     

    Picture for pivot as solution

    Picture for Fact table column Band