Join in Pivot Table

[Anonymous]

Hi All

I am trying to use outer join but output was not accurate when I try to show it in Pivot Table,it was working fine when output shown in Table Box.Anyone please help me in this issue.

My sample data looks like:

Product:

Load * Inline [

ProductID,Product

1,aaa

2,bbb

3,ccc ];

Outer Join(Product)

Sales:

LOAD * Inline [

ProductID,Product,SalesAmount

1,aaa,10

2,bbb,20

4,ddd,40

5,eee,50 ];

Sample Output(Pivot Table):

Product ID	Product	SalesAmount	Sum(SalesAmount)
1	aaa	10	10
2	bbb	20	20
4	ddd	40	40
5	eee	50	50

Output Table Box:

Product ID	Product	SalesAmount
1	aaa	10
2	bbb	20
3	ccc	-
4	ddd	40
5	eee	50

[sunny_talwar · Accepted solution]

I think you need to uncheck 'Suppress Zero Values' on the presentation tab of chart properties

[sunny_talwar]

[Anonymous]

Thank you Sunny