Need to show Total Label in place of Null when expression returns zero

[mahesh_agrawal]

Hi Folks,

I have a Pivot Table in my attached QVW which shows count of sal for each name for the possible values of Country_Name field.

As per the requirement, the table should always show all values of name along with the Total at bottom.

When I select a Country_Name value for which "Sal" value is available, the table works fine. But, when a Country_Name value with no "Sal" is selected, the chart shows Null at the bottom of name column. It is understandable as we don't have any name for the selected Country_Name. But the user wants to see some label instead of the Null.

Please help. Thanks in advance.

Cheers,

Mahesh

[Gysbert_Wassenaar · Accepted solution]

See attached example

[lironbaram]

hi

have a look at the attach example