Cells with zero values

[#1]

Hi all, anyone can help me?

In a Pivot Table I show the data of sales of each agent and each client. If I select a year, disappear the data related to the customer who did not have sales for the year selected. How can I do to show even customers without sales for the year selected by setting 0 in sales?

Thank All

[sunny_talwar]

May be you need to go to presentation tab and uncheck 'Suppress Zero-Values' option

[#3]

hi Sunny T

Thank you for your help. I tried but not working.

When I select the year, they disappear the lines for customers who have no sales in the selected year.

[israelcsouza]

Hi Marino,

May be you need to go to Dimensions Tab and check 'Show All Values' option:

[awhitfield]

Hi Marino,

can you upload an example .qvw please?

Andy

[florentina_doga · Accepted solution]

!hi,

i find a solution for your problem.

[settu_periasamy]

Hi,

May be  try these steps :

'Show All Values' in the Dimension tab.

In the Presentation tab

Uncheck 'Suppress Zero-Values'

Null Symbol -> set as 0

Missing Symbol -> set as 0

[#8]

Thank very, very.....