Pivot Chart problem

[rohitians]

Hello,

I have a pivot chart of sales the problem is I hav null dimension values but i cant suppress null i need its sales values,

how can i avoid displaying those null divisions..

Thanks and Regards,

Rohit Yadav

[er_mohit]

in presentation tab uncheck the suppress zero values

hope it helps

[Anonymous]

Hi

You can use RecNo() function and get all the rows in that particular table. Then in chart we can hide the RecNo field and display all the other diemensions and expressions. Please find the attached Sample.

Regards

Revathy.