Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Outer Join Does Not Works

Hi All, I have data in form of below 2 tables: Table 1   Table 2   I joined these 2 tables with all data from table 1 and matching data from table 2.    When I try to pull Table1....
  • Aron_Moore's avatar
    8 years ago

    Couple ways to do this:
    Click "Show items with no data", that'll bring in blanks and not zeros.

    Probably best to create a measure that sums the counts from table 2 and use that instead of the related column.