display problem

[GraceGao]

Hi Experts

I would like to display the non-value record, but there is not working even i set the include zero value.

I have customer table and there is order table, i want to display the all customer and by month to display if the customer have orders. howerver, i encoutered there display which customer have orders. Please help. 

[MayilVahanan]

HI @GraceGao 

Its working fine for me

Data:

CrossTable(MonthYear,Value,1)
Load * Inline
[
Customer, 201909,201910,201911
A101, 1, 0,0
A120,0,1,0
A130,0, 0, 1
A140, 0, 0, 0
A150,0, 0, 0
];

setting:

[GraceGao]

Hi MayiVahanan

Thanks for your reply. 

Below is backend table structure, there is customer and order table, and i left join customer table and order table the result is as below result in blue. others are null value,so i guess it is not working if i select include zero values.

is there any way to achieve this? Thanks.

[MayilVahanan]

Hi @GraceGao 

Fact:
Load * Inline
[
Customer,YearMonth,Orderno
A101, 202009,aaa
A120,201910,bbb
A130,201911,cc
];

cust:
Load * Inline
[
Customer
A101
A120
A130
A140
A150
];
Join(cust)
Load distinct YearMonth Resident Fact;

Join(Fact)
Load * Resident cust;

Drop Table cust;

O/P:

[GraceGao]

It is working. Thanks.