Forum Discussion

TomerA's avatar
TomerA
Cloud Apps
12-28-2021
Solved

Show blank values in pivot table instead of not showing line at all

Hi, In the data model I have main table that is linked to another table using an index. Not all rows exists on the other table. When I try to display in the Pivot table column from the other table...
  • wallingfordce's avatar
    01-10-2022

    Hi TomerA -

    Sisense requires that either all main table values exist in the other table, or you need to create an intermediary/bridge table with all distinct values from the main table left joined to the other table, and a null replacement for the main table values that don't exist in the other table.