Forum Discussion
Calculate From Another Table And Apply Filters From Other Table
Below is a screenshot of a very simple example of what I am trying to do. The PClaims is the raw data. Notice in yellow, B is missing Code "2". In my base table, I have it set up so that each affiliation_II has each code, so there is a line for Affiliation_II B and Code "2". The reason I have this Base table instead of just using PClaims is so that each Affiliation_II has every single code, even if it is missing in the raw data.
Community SupportHi gillyr7 ,
Please confirm my below understanding is correct:
1. There're 2 tables both created under query editor, Base table is not the calculated table of Pclaims.
2. You'd like to make sure each Affiliation_II has every single code, but how does the code 2 of B come from? could you please clarify?
3. The price column in basetable is a measure, but the "50" makes me confused coz code 2 doesn't appear in the pclaims table. how does the "50" come from?
4. Need to know the detailed question and the expected result you wanna get.
I'd like to provide the further support once get the clarification.
Best regards,
Dina Ye