Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create a Table with Custom Cumulative total

Hi,   I have a RAW Table like this: RAW_Table Code Current_Phase AA1 Phase 1 AA2 Phase 3 AA3 Phase 2 AA4 Phase 5 BB1 Phase 6 BB2 Phase 6 CC1 Phase 4 CC2 Phase ...
Need Help
  • DataZoe's avatar
    DataZoe
    4 years ago

    Anonymous Another approach is also to create a table with all phrases for the current phrase, and join it. 

     

    Join on Current Phase (M-M relationship)

     

    Then you can just just All Phases and row count from main table.

     

     

DataZoe's avatar
DataZoe
Microsoft Employee
4 years ago

Anonymous Another approach is also to create a table with all phrases for the current phrase, and join it. 

 

Join on Current Phase (M-M relationship)

 

Then you can just just All Phases and row count from main table.