How to list all Dim companies even there are no Fact sales rows

[Anonymous]

I have Dimension table Region (Country, City, CompanyId, CompanyName). I have Fact table Sales (SalesId, CompanyId, Amount). Tables are joined with CompanyId column.

I have Matrix reports with columns Country, City, Company, SalesAmount.

I need to list all companies no matter if there were sales at all. Currently I see only companies where sales rows exits. 

[MartynRamsden · Accepted solution]

Hi @Anonymous 

Select your matrix then in the Visualizations pane, find the 'Company' field.

Right click and select 'Show items with no data'.

Best regards,
Martyn

If I answered your question, please help others by accepting it as a solution.