what is the reason?

[soniasweety]

Hi all,

i have a different issue   i just want to know the reason behind that

i have  a filter with  market and  country    and  one pivot table     if i select   one country and one market value   

the sum(value) =0   which is correct but     the table is showing  zero   as a result.

my req:  is   table should not show anything  empty table should show,

[Anil_Babu_Samineni]

From Layout tab, Disable the feature called "Size to Data"

[jakobjosef]

Hi Sony,

I think you need to surpress zero values:

Open Properties, Register "Dimension", then "surpress 0-values":

Hope this helps.

Jakob