table diagram

[#1]

hi all.

i am using a table diagram with one dimension and one formula to display certain information (dimension = examtypes; formula: total passes in examtype.)

if - for example there are 3 examtypes A, B and C and a selected company has passed A (2 times) and B  (one time) and did not participate in C yet, my diagram shows:

exam A	2
exam B	1

what i want is the diagram also to display a third line that shows

exam C

0

is this possible within this diagram type ?

if not, how can it be done ?

thanks a lot for any hints.

regards.

K

[Miguel_Angel_Baeyens]

Hi,

Go to the chart properties, Presentation tab, and uncheck "Suppress Zero Values" in a straight table or pivot table.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica