Data Against Unselected Values in Chart

[Anonymous]

Dear All,

I have a Requirement where

i have data in this format

Month	Country	Amount
Jan	US	100
Jan	UK	200
Jan	UAE	300
Jan	Germany	400
Jan	Italy	600
Feb	US	700
Feb	India	800
Feb	Canada	900
Mar	US	100
Mar	France	110
Mar	Finland	1200

and output of chart is

Month	Jan	Feb	Mar
Country
US	100	700	100
UK	200	0	0
UAE	300	0	0
Germany	400	0	0
Italy	600	0	0
India	0	800	0
Canada	0	900	0
France	0	0	110
Finland	0	0	1200

If a User Selects Jan

then we get Data in this Format

Month	Jan
Country
US	100
UK	200
UAE	300
Germany	400
Italy	600

But i want Data in

Month	Jan
Country
US	100
UK	200
UAE	300
Germany	400
Italy	600
India	0
Canada	0
France	0
Finland	0

Please Help me ASAP

Please Help me out

[CELAMBARASAN]

Hi,

     Use pivot table and drag the month dimension to horizontal

     Month and Country should be dimension

     Sum(Amount) should be expression.

Celambarasan

[Anonymous]

Dear Celambarasan

But if a User Selects Jan Month then Chart Get Reduced to

Month	Jan
Country
US	100
UK	200
UAE	300
Germany	400
Italy	600

But i want

Month	Jan
Country
US	100
UK	200
UAE	300
Germany	400
Italy	600
India	0
Canada	0
France	0
Finland	0

[CELAMBARASAN · Accepted solution]

Hi,

     Chart properties-->Presentation tab-->Uncheck the suppress zero values option.

     ChartProperties-->Dimension-->Show all values

Celambarasan

[Anonymous]

Thnxs a Ton

Celambarasan