pivot table

[#1]

Hi All,

I am facing a problem in pivot table. if the values in all columns are null it is not displaying the row.

Please find the attached QV file. Appreciate if some one help me.

Thanks

[engishfaque]

Dear Selva,

Solved proble, follow the Steps:

Chart Properties > Dimensions > Uncheck Suppress When Value is Null

Kind regards,

Ishfaque Ahmed

[VishalWaghole]

Hi SelvaDXB,

That ignores the NULL values, Coz u have check "Suppresses When Value Is Null"

Try with un checking this.

-- Regards,

Vishal Waghole

[#4]

Hi,

I tried this  "Chart PROPERTIES > Dimensions > Uncheck Suppress When Value is Null"

Still i am facing the issue.

[#5]

Hi,

I tried this  "Chart PROPERTIES > Dimensions > Uncheck Suppress When Value is Null"

Still i am facing the issue and it is displaying one more extra row before total.