Show all data

[#1]

Hi All,

I have 2 tables:

Load * Inline

[Region

Brazil

Italy

Japan

];

Load * Inline

[Region,Revenue

Brazil,1

];

But when I use Pivot table to show the Revenue By Region, it only shows Brazil, how can I show all regions even there is no revenue in the second table?

Thanks.

[#2]

Hi,

Presentation-->uncheck Suppress Zero values

[ecolomer]

Select option "Show all values" in dimension

[jyothish8807]

Hi Isaac,

PFA

Regards

KC

[prma7799]

Hi,

1) Go to Presentation

2) Unchecked Suppress Zero-values

Thanks,

Prashant

[ashwanin]

Go to chart properties-->Presentation-->Region-->Supress Zero Value