Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Net movement between categories

Hi All, I am tracking movement of members between categories, "Affiliate", "Fellow" etc. Members can move both ways between these categories, e.g. from Affiliate to Fellow, and from Fellow to A...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for your reply. It certainly works re the calculation logic.

 

The issue I have is that I would like to show the movement between specific categories, i.e.:

 

Prior   Current   Net

Affiliate   Fellow   +2

Member   Fellow   -4

Affiliate   Member   +6

 

I can't quite work out how I want to handle this, because there will always be an equal and opposite movement for each Prior / Current combination, so the total movement will = 0.

 

I guess I need to define the Prior / Current category combinations, but not sure how to go about that.

 

Thanks for taking the time to work up the pbix and replying.

 

Rich

Krishna_Mysore's avatar
Krishna_Mysore
Helper II
7 years ago

Please provide sample data showing expected result(An excel file will do) . Without this it is difficult to investigate further.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    I'm going to close this because I can't get it clear in my head what I'm trying to do, which doesn't make it easy on you!

     

    Thanks

    Richard